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.
What is causing this problem?
CA Datacom environment running CA Dataquery
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
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.