CICS negative URT numbers DB00622I - COMM CLOSE IGNORED OPEN WITH USERS

Products

• Datacom
• DATACOM - AD
• Datacom/AD

Issue/Introduction

Unable to close a DBID in Datacom, getting error message DB00622I. 

The DBID was first closed in CICS with DBOC CLOSE=nnn

Then trying  to close the DBID in the MUF with F MUF,CLOSE nnn , gets error message:

DB00622I - COMM CLOSE nnn IGNORED, OPEN WITH USERS

Checked in CICS and still shows as closed  F CICS,DBOC INQ=nnn.???

+DBOC INQ=???.???.nnn                                            
DELIM &                                                            
+URT nnn(STD CLOSED        )                       PRTY=10 TXNUD  
+    nnn TABLE:RCP  DBID:nnnn  UPDATE      SYNONYM               
+DC00380I  TRANSACTION COMPLETED.                                  

Running DBUTLTY ACCESS STATUS=OFF,DBID=nnn,USERS=FAIL shows CICS has the DBID open.

The DCOPEN command in Sysview shows a negative URT numbers, -34 under the URTNum column 

Running DBSLQPR with SELECT * FROM SYSADM.MUF_OPEN_BASES  WHERE DBID = nnn shows a very large URT number  65502.

 

Environment

Release : 15.1

Resolution

Negative URT numbers are URTs that have been dynamically created by SQL.

These are created when application programs that issue SQL commands or from dynamic SQL in CICS using DQRY or  DDOL SQL mode.

You can confirm this by running the following SQL query against dynamic system table SQL_STATUS_URT for the DBID you're trying to close:
SELECT * FROM SQL_STATUS_URT WHERE DBID = nnn;

Column CLS_OPT is the plan close option (PLNCLOSE) and indicates when the URT will be closed. 
URTs opened with plan option PLNCLOSE=R are not closed until the SQL URT (default is 20) is closed.

To release the negative SQL URTs you have to close the SQL URT 20.
Closing the SQL URT will prevent all SQL access so you need close it and then reopen it, do the following:

1. Issue CICS command:
   DBOC CLOSE=20
   
   
2. Wait for it to complete then issue CICS command:
   DBOC OPEN=20 or DBOC RESTART=20