why my SQL URT is not OPEN automatically under my CICS.

Article Id: 16146
Status: Published
Updated On: 14-02-2018 07:50
Legacy Id: TEC1330932
Products:
CA Datacom
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.