When is the new DBUTLTY COMM OPTION=CLOSE, DBID=n function required?

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB
• Datacom/Server

Issue/Introduction

When is the new DBUTLTY COMM OPTION=CLOSE, DBID=n function required?

Environment

Release: Datacom

Resolution

If you have defined MUF ACCESS OPTIMIZE for a database, but have not opened the database, the DBUTLTY COMM OPTION=CLOSE,DBID=n function is not required. Once a database has been opened for update by ANYTHING, it remains open to the Multi-User even if a DBOC CLOSE is issued and there are no batch jobs running against it. In this case, you must run the COMM CLOSE for any Datacom function that indicates the database cannot be open for update. This includes ACCESS OFF, REORG processing, normal INIT, LOAD and RETIX processing, and Native BACKUPs and EXTRACTs.

The general rule is: If the database must be closed and you have ACCESS OPTIMIZE (the default) coded in the startup-options for that database, issue a COMM CLOSE.