M204.0843: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
 
m (minor formatting)
Line 8: Line 8:
<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></li>


<li><P class="code">CHECKPOINT TIMED OUT ON <i>yy.ddd hh:mm:ss.th</i> UPDATING FILE <i>filename</i> </P>
<li>The following form can only occur when the <var>DKUPDTWT</var> parameter is greater than zero:
<P>
<P class="code">CHECKPOINT TIMED OUT ON <i>yy.ddd hh:mm:ss.th</i> UPDATING FILE <i>filename</i> </P></li>
This form can only occur when the <var>DKUPDTWT</var> parameter is greater than zero. </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>
<ul>
<P class="code">CHECKPOINT COMPLETED ON <i>yy.ddd hh:mm:ss.th</i> </P>
<li><P class="code">CHECKPOINT COMPLETED ON <i>yy.ddd hh:mm:ss.th</i> </P></li>


<li><P class="code">SUB-TRANSACTION CHKP ID: <i>nnnnn hh:mm:ss.th</i> </P></li>
<P class="code">SUB-TRANSACTION CHKP ID: <i>nnnnn hh:mm:ss.th</i> </P>
</ul>
<P>
<P>
If it is about abort, the message is:</P>
If it is about abort, the message is:</P>
Line 39: Line 36:
parameters or to revise the application's update strategy.</P>
parameters or to revise the application's update strategy.</P>
<P>
<P>
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 second case may be indicated by the occurrence of the <code>FILE</code> 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 <var>LDKBMWND</var> 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 <var>LDKBMWND</var>.
the number of buffers allocated in the run and the setting of the <var>LDKBMWND</var> 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
</P>
be traced to a specific, poorly behaving program, then consider increasing <var>LDKBMWND</var>.</P>
<p class="note"><b>Note:</b> It is possible for the <code>FILE</code> 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 <var>CPTO</var> or <var>CPTQ</var>,
<p class="note"><b>Note:</b> 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 <var>CPTO</var> or <var>CPTQ</var>,
there will be insufficient time to write even a small number of modified pages to disk.
there will be insufficient time to write even a small number of modified pages to disk.
</P>
</P>
{{Template:M204.0843 footer}}
{{Template:M204.0843 footer}}
<!-- skeleton as it was in pdf//-->
<!-- skeleton as it was in pdf//-->

Revision as of 20:22, 15 March 2018

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:

  • CHECKPOINT 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(...)

  • 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

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.

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