M204.0843: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
(Corrected various formats of the message and changed to lower case)
 
Line 3: Line 3:
<ul>
<ul>
<li>Basic message format:
<li>Basic message format:
<P class="code">CHECKPOINT TIMED OUT ON <i>yy.ddd hh:mm:ss.th</i> DUE TO USER <i>nn</i> </p></li>
<P class="code">Checkpoint timed out on  <i>yy.ddd hh:mm:ss.th</i> due to user <i>nn</i> </p></li>
 
<li>Sub-transaction checkpoint time out message:
<P class="code">Sub-tran CP timed out on  <i>yy.ddd hh:mm:ss.th</i> due to user <i>nn</i> </p></li>


<li>An alternate form if additional information is available:
<li>An alternate form if additional information is available:
<P class="code">CHECKPOINT TIMED OUT ON <i>yy.ddd hh:mm:ss.th</i> DUE TO USER <i>nn</i> <i>userid</i> RUNNING <i>procname</i>(...)</P></li>
<P class="code">Checkpoint timed out on  <i>yy.ddd hh:mm:ss.th</i> due to user <i>nn</i> <i>userid</i> running <i>procname</i>(...)</P>
<P class="code">Sub-tran CP timed out on  <i>yy.ddd hh:mm:ss.th</i> due to user <i>nn</i> <i>userid</i> running <i>procname</i>(...)</P>
</li>


<li>The following form can only occur when the <var>DKUPDTWT</var> parameter is greater than zero:
<li>The following form can only occur when the <var>DKUPDTWT</var> parameter is greater than zero:
<P class="code">CHECKPOINT TIMED OUT ON <i>yy.ddd hh:mm:ss.th</i> UPDATING FILE <i>filename</i> </P></li>
<P class="code">Checkpoint timed out on  <i>yy.ddd hh:mm:ss.th</i> updating file <i>filename</i> </P></li>
</ul>
</ul>
<p>
<p>
If it is about completion, the message is one of these: </p>
If it is about completion, the message is one of these: </p>
<P class="code">CHECKPOINT COMPLETED ON <i>yy.ddd hh:mm:ss.th</i> </P>
<P class="code">Checkpoint completed on  <i>yy.ddd hh:mm:ss.th</i> </P>


<P class="code">SUB-TRANSACTION CHKP ID: <i>nnnnn hh:mm:ss.th</i> </P>
<P class="code">Sub-transaction CHKP ID: <i>nnnnn hh:mm:ss.th RCV=nnn</i> </P>
<P>
<P>
If it is about abort, the message is:</P>
If it is about abort, the message is:</P>
<P class="code">SUB-TRANSACTION CHECKPOINT ATTEMPT ABORTED BY USER: <i>nn</i> </P>
<P class="code">Sub-transaction checkpoint attempt aborted by user: <i>nn</i> </P>
<P>
<P>
In these messages: </P>
In these messages: </P>
Line 24: Line 29:
<li><var class="term">yy.ddd</var> is the Julian date. </li>
<li><var class="term">yy.ddd</var> is the Julian date. </li>
<li><var class="term">hh:mm:ss.th</var> is time in hours, minutes, seconds, and tenths/hundredths of seconds. </li>
<li><var class="term">hh:mm:ss.th</var> is time in hours, minutes, seconds, and tenths/hundredths of seconds. </li>
<li>RCV=nnn is the number of blocks needed for sub-transaction recovery.  The size of the recovery checkpoint dataset must be greater
than the sum of the last RCV value plus the number of records in RESTART and RESTARTS.
</li>
</ul>
</ul>
<P>
<P>

Latest revision as of 01:21, 4 October 2023

M204.0843  token This is an informational checkpoint message, which is written to both the audit trail and to the operator. The message is about timeout, abort, or completion. If it is about timeout, it will be one of these:

  • Basic message format:

    Checkpoint timed out on yy.ddd hh:mm:ss.th due to user nn

  • Sub-transaction checkpoint time out message:

    Sub-tran CP timed out on yy.ddd hh:mm:ss.th due to user nn

  • An alternate form if additional information is available:

    Checkpoint timed out on yy.ddd hh:mm:ss.th due to user nn userid running procname(...)

    Sub-tran CP timed out on yy.ddd hh:mm:ss.th due to user nn userid running procname(...)

  • The following form can only occur when the DKUPDTWT parameter is greater than zero:

    Checkpoint timed out on yy.ddd hh:mm:ss.th updating file filename

If it is about completion, the message is one of these:

Checkpoint completed on yy.ddd hh:mm:ss.th

Sub-transaction CHKP ID: nnnnn hh:mm:ss.th RCV=nnn

If it is about abort, the message is:

Sub-transaction checkpoint attempt aborted by user: nn

In these messages:

  • yy.ddd is the Julian date.
  • hh:mm:ss.th is time in hours, minutes, seconds, and tenths/hundredths of seconds.
  • RCV=nnn is the number of blocks needed for sub-transaction recovery. The size of the recovery checkpoint dataset must be greater than the sum of the last RCV value plus the number of records in RESTART and RESTARTS.

System manager response: Checkpoint time-outs can be caused by one or both of the following problems:

  1. The duration of typical update units is long compared to the CPTO or CPTQ parameters. Update units that span terminal I/O are a common example.
  2. There are a very large number of modified pages in the buffer pool at the time a checkpoint is attempted, and it takes more than CPTO or CPTQ seconds to write them all to disk.

The first case should be addressed by reviewing update unit logic for the presence of COMMIT statements prior to terminal I/O statements. If that is not the problem, then it may be necessary to increase one of the parameters or to revise the application's update strategy.

The second case may be indicated by the occurrence of the FILE version of the timeout message. If this message is seen frequently, it may indicate that the Anticipatory Write Window is too small. The difference between the number of buffers allocated in the run and the setting of the LDKBMWND parameter controls the maximum number of unwritten modified buffers that can be in the buffer pool at a given time. If this message appears frequently, and time-outs cannot be traced to a specific, poorly behaving program, then consider increasing LDKBMWND.

Note: It is possible for the FILE version of the timeout message to appear, even though the problem is not the Anticipatory Write Window. If the typical duration of update units is very close to the setting of CPTO or CPTQ, there will be insufficient time to write even a small number of modified pages to disk.

Message attributes:

RETCODEO=0Sets online return code
RETCODEB=0Sets batch (single user) return code
CLASS=IInformation class; the message can be suppressed with the X'02' bit setting of the MSGCTL parameter
AUDITMSWrites the message with line type MS to the audit trail
NOCOUNTDoes not increment the error count (ERCNT) parameter
NOTERMDoes not display the message on the user's terminal
OPRWrites the message to the (operator) console

Back to list of messages