DC111111 JOURNAL 90+% FULL AFTER CONDENSE
search cancel

DC111111 JOURNAL 90+% FULL AFTER CONDENSE

book

Article ID: 113098

calendar_today

Updated On:

Products

IDMS IDMS - Database

Issue/Introduction

This document describes the meaning and the recommended action to take when you see the message:
IDMS DC111111 REPLY 01 CV 1 JOURNAL 90+% FULL AFTER CONDENSE - CALL DBA BEFORE REPLYING

When a CA IDMS system journal fills, the CV automatically swaps to a new system journal and submits an archive journal job to condense the full one and write its contents to an archive journal file.
During the condense process, BFOR images for all transactions that were active at the time of the journal swap are saved in the system journal in what are called "condensed segments".
(CA-IDMS has to do this in order to be able to recover any transaction that may abend after the journal swap.)

If a transaction performs too many database updates without issuing COMMITs frequently enough, these condensed segments can build up over time and fill the system journals.
If the archive journal job detects that the system journal is still more than 90% full of condensed segments after the condense phase, it issues a message such as this:
IDMS DC111111 REPLY 01 CV 1 JOURNAL 90+% FULL AFTER CONDENSE - CALL DBA BEFORE REPLYING

Note, the DC111111 message id is a generic message definition used by archive journal utility for various different conditions.
The information in this document only applies to the condition with the "JOURNAL 90+% FULL AFTER CONDENSE" text.

Environment

CA IDMS, all supported releases.

Resolution

This DC111111 message is written to the operator's console and must be replied to.
Any reply is valid and will allow the archive journal job to continue.
The purpose of the message is to draw your attention to this condition and that some user response is highly advisable.

The most important action to take is to identify the long-running transaction which is causing the journals to fill and cancel it.
Most likely it is a batch job but could also be an online transaction, in which case you can use OPER to cancel it (OPER may also be useful in identifying the offending transaction).

Do NOT cancel the archive journal job.
Do NOT cancel the CV job.
Doing so will potentially impact the recovery process and require more complicated manual intervention.

By cancelling the offending task, the CV will roll out the transaction and the cycle of archive journals should eventually see the journals return to normal and the archive jobs will no longer issue the "90+% FULL" message.
 

Additional Information

DC111111
Journaling Procedures
ARCHIVE JOURNAL
OPER Task Commands
JOURNAL 90+% FULL AFTER CONDENSE threshold change