DC111111 JOURNAL 90+% FULL AFTER CONDENSE
Article ID: 113098
Updated On:
Products
Issue/Introduction
This document describes the meaning and the recommended action to take when an archive journal job writes the following message to the operator's console:
IDMS DC111111 REPLY 01 CV 1 JOURNAL 90+% FULL AFTER CONDENSE - CALL DBA BEFORE REPLYING
Environment
Release: All supported releases.
Cause
When an IDMS CV journal fills (or is manually varied), the CV automatically swaps to a new CV journal and submits an archive journal job.
The archive journal job has two phases. First, it archives the contents of the journal that just filled to an archive file. Second, it condenses that journal.
During the condense phase, it saves the BFOR images for all of the transactions that were active at the time of the journal swap in what is called a "condensed segment". IDMS has to do this in order to be able to recover any of those transactions that abend after the journal swap. The presence of the condensed segment means that there is less space available in the remainder of that journal for the next time the CV needs to use it.
If a transaction performs too many database updates without issuing COMMITs frequently enough, the condensed segments can build up over time and fill the CV journals. At the end of the condense phase, the archive journal job checks how much of the journal is filled with condensed segments, and if it exceeds 90%, it writes the above DC111111 message to the console.
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.
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 the user's attention to this condition and that some manual intervention is essential.
Do not simply reply to this message without taking appropriate action. Failure to react appropriately may result in critical DC205024 errors in the CV and/or DB002532 errors in the archive journal job.
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 so be an online transaction, in which case you can use OPER to cancel it (OPER may also be useful in identifying the offending transaction). Then issue enough DCMT VARY JOURNAL commands to cycle through each CV journal and free up space in the journals. This is described in more detail under the heading Handling Full Journal Files on the Offloading Disk Journal Files page.
Do NOT cancel the CV or any archive journal job. Doing so will potentially impact the recovery process and require more complicated manual intervention.
Additional Information
Journaling Procedures
Waiting on Full Journal Message at Database Operations
JOURNAL 90+% FULL AFTER CONDENSE threshold change
Feedback
