From the Dynamic System Tables (DST), how to tell what URTs have a Datacom database open?

book

Article ID: 21865

calendar_today

Updated On:

Products

CA Datacom CA DATACOM - AD CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

Question:

Is there a Datacom Dynamic System Table (DST) that I can query to determine what URTs have a database open? When I attempt to close a database after an ACCESS OFF, the DB00607I message indicates that the base is open for read in a CICS region:

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

Answer:

A Datacom SQL request can be submitted against the DST named MUF_OPEN_BASES.

For example:

     SELECT * FROM MUF_OPEN_BASES WHERE DBID = dbid;

This will show 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. Refer to the CA Datacom/DB System Tables Reference Guide for additional information on the available DSTs.

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 CA Datacom/DB System Tables Reference Guide

https://supportcontent.ca.com/cadocs/0/CA%20Datacom%2014%200%20Public-ENU/Bookshelf_Files/PDF/DatacomDB1402--System_Tables_Ref_ENU.pdf

 

 

Environment

Release:
Component: DB