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

Document ID : KB000016146
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

 

 

Question:

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

 

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.