why my SQL URT is not OPEN automatically under my CICS.
book
Article ID: 16146
calendar_today
Updated On:
Products
CA Datacom - DBCA DatacomCA Datacom - ADCA Datacom - Server
Issue/Introduction
In the CICS region, why won't my SQL URT open automatically?
Environment
z/os, CA Datacom/DB 14.0, DBC 14.0 and above.
Resolution
For the SQL URT to be opened automatically by CA Datacom CICS Services (DBC), the SQL URT (generally URT 020) should not be defined in the DBCVTPR AUTO or DEFER parameter list.
There are two methods to open an SQL URT:
Manually, by explicitly using the DBC command DBOC OPEN=20.
Automatically, at CICS region PLT startup as long as URT 20 is not defined in the AUTO or DEFER list parameter.
Additional Information
Note: A URT defined with SQL=YES is not eligible for AUTO= specification.