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:



To check the number of IDMS Server connections:



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.