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

Products

• Datacom
• DATACOM - AD

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.