ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC EASYTRIEVE REPORT GENERATOR FOR COMMON SERVICES INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET 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