DBUTLTY COMM OPTION=CLOSE,DBID=nnnnn fails with 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.
Datacom environment running 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 an SQL query to find the jobname:
SELECT * FROM SYSADM.MUF_OPEN_BASES WHERE DBID = nnnnn
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. It needs to be closed with DBOC CLOSE=000.
If you want to work with standard URTs only and you do not want SQL to dynamically generate a URT then
assemble/link DQSYSTBL using DQOPTLST OPNDURT=N.