Eddy_G

CA Tuesday Tip: (CA IDMS) Error message DB006056 using the SQL Web Connect feature

Discussion created by Eddy_G Employee on Aug 13, 2014

CA IDMS Tuesday Tip by Edward Gorga, Principal Support Engineer for August 12, 2014

 

When using the the SQL Web Connect feature, you may see this error:

 

DB006056 Tnnn C-4M330: The CA IDMS SQL Option is not installed.

Request refused because of SQL restrictions, reason: NOT VDBA SCHEMA.

 

The reasons for the error can be any one of the following:

 

  • The CA Common Services License Seat Registration Service is not installed
  • The CA Common Services CAMASTER address space is not active.
  • The limit of 2 SQL sessions or 2 IDMS Server connections has been exceeded.

 

You can check how  many SQL sessions are registered with the z/OS console command:

DISPLAY PROD,REGISTERED,ID(GT)

 

To check the number of IDMS Server connections:

DISPLAY PROD,REGISTERED,ID(XS)

 

For further details in installing and using the SQL Web Connect feature see the scenario How to Use SQL Web Connect

 

Also see TEC597925 and the Installation and Maintenance Guide for z/OS chapter SQL Web Connect.

Outcomes