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:
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.