More daily spills after upgrading to Datacom 14.0

Products

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

Issue/Introduction

After an upgrade from Datacom 12.0 to 14.0, the logging data (LXX) being spilled to the Recovery file (RXX) via the DBUTLTY SPILL process increased dramatically. The number of spills went from 1-2 per day to over 30 per day.

Environment

Release: 14.0

Cause

After running DBUTLTY REPORT AREA=RXX,LOGPRINT=DETAIL it became clear that Logged records for maintenance on accounting tables filled up the RXX file. Those accounting tables should not have been opened in this Datacom Multi-User production environment.

Resolution

Close the accounting tables in this Multi-User via MUF console command ACCT CLOSE ALL or by running DBUTLTY  ACCT OPTION=CLOSE,TABLE=ALL.