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.???
+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.
Release : 15.1
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: