RC 46 and SQL dynamically generated URT

Products

• Datacom
• Datacom/DB

Issue/Introduction

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.

Environment

z/OS   z/VSE

Datacom environment running Dataquery.

all versions

Resolution

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

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

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.

Additional Information

See Tailoring the Dataquery System Option Table