How to avoid the creation of SQL dynamically generated URTs?

Document ID : KB000021741
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction: 

DBUTLTY COMM OPTION=CLOSE,DBID=nnnnn fails with CA Datacom RC 46 and the Multi-User(MUF) log shows message:

DB00622I COMM close/stats n IGNORED, OPEN WITH USERS

The Standard User Requirements Table(URT) for this base has been closed in CICS and no batch job is running that accesses this database.

Question: 

What is causing this problem?

Environment:  

z/OS   z/VSE

CA Datacom environment running CA Dataquery

Answer: 

DBUTLTY ACCESS STATUS=OFF,DBID=nnnnn,USERS=FAIL gives the name of the active job holding the base open via message DB00607I.

You can also run SQL query SELECT * FROM SYSADM.MUF_OPEN_BASES WHERE DBID = nnnnn to find the jobname.

If you find that a CICS job holds the database open then go into that CICS and enter

DBOC INQ=???.???.nnnnn

If you find URT 000(DYN OPEN AUTO ) then an SQL dynamically created URT has been built for Dataquery.

If you want to work with standard URTs only and you do not want SQL to dynamically generate a URT then

assemble/link-edit DQSYSTBL using DQOPTLST OPNDURT=N.