Showing from the Datacom DST what CICS URT holds the base open

Products

• Datacom

Issue/Introduction

Running DBUTLTY ACCESS OFF on a database shows in the Datacom MUF 

DB00607I - BASE dbid ACCESS OFF ACTIVE JOB(S) cicsjob(BASE IS OPEN READ) JOB- jobname NUMBER-nnnnn .

This article provides a way to find the CICS user requirements table ( URT) that holds the database open.

Environment

Datacom 

Resolution

A Datacom SQL request can be submitted against the Dynamic System Table (DST)  named MUF_OPEN_BASES.

For example:

     SELECT * FROM MUF_OPEN_BASES WHERE DBID = dbid;

This shows the MUF_NAME, DBID, JOB_NAME, URT_DBID, URT_NUMBER and several other columns of information related to open databases. One row exists for every open URT. 

Once you identify the open URT(s) associated with the DBID that you wish to close, you can use the Datacom CICS Services command to close each open URT:

      DBOC CLOSE=urt_number

Note: you could also identify the open URT(s) to be closed in the CICS region using the CICS Services command:

      DBOC INQ=???.???.dbid

Additional Information

Refer to the online documentation : MUF_OPEN_BASES (MFB)