MONITOR command: Checkpoints-transaction and sub-transaction: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (Automatically generated page update)
 
 
(2 intermediate revisions by the same user not shown)
Line 6: Line 6:
<dd>Enables system administrators to verify the date and time of the last successful checkpoint. Other valuable information, such as the number of timeouts since the successful checkpoint, the number of users preventing checkpoints, and the current size of CHKPOINT, can be displayed.
<dd>Enables system administrators to verify the date and time of the last successful checkpoint. Other valuable information, such as the number of timeouts since the successful checkpoint, the number of users preventing checkpoints, and the current size of CHKPOINT, can be displayed.
</dl>
</dl>
==Syntax==
==Syntax==
<p class="syntax"><b>M</b>ONITOR {CHECKPOINT | CHKP | SUBTRAN} [USERLIST] [SL]
<p class="syntax"><b>M</b>ONITOR {CHECKPOINT | CHKP | SUBTRAN} [USERLIST] [SL] [EVERY <span class="term">n</span>] [SERV]
[EVERY <i>n</i>] [SERV]
</p>
</p>
   
   
<b>Where:</b>
Where:
<table>  
<table>  
<tr>
<tr>
<th><var>CHECKPOINT</var></th>
<th><var>CHECKPOINT</var></th>
<td> or <var>CHKP</var> causes basic informational messages for transaction checkpoints to appear. CHKP is the abbreviation for CHECKPOINT.</td>
<td>Causes basic informational messages for transaction checkpoints to appear. <var>CHKP</var> is the abbreviation for <var>CHECKPOINT</var>.</td>
</tr>
</tr>
   
   
<tr>
<tr>
<th><var>SUBTRAN</var></th>
<th><var>SUBTRAN</var></th>
<td> causes basic information messages for sub-transaction checkpoints as well as transaction checkpoints to appear.</td>
<td>Causes basic information messages for sub-transaction checkpoints as well as transaction checkpoints to appear.</td>
</tr>
</tr>
   
   
<tr>
<tr>
<th><var>USERLIST</var></th>
<th><var>USERLIST</var></th>
<td> causes the basic user line to appear for every user who inhibits checkpoints.</td>
<td>Causes the basic user line to appear for every user who inhibits checkpoints.</td>
</tr>
</tr>
   
   
<tr>
<tr>
<th><var>SL</var></th>
<th><var>SL</var></th>
<td> specifies to display the since last statistics.</td>
<td>Displays the since last statistics.</td>
</tr>
</tr>
   
   
<tr>
<tr>
<th><var>EVERY n</var></th>
<th><var>EVERY</var> n</th>
<td> is the number of seconds <var class="product">Model&nbsp;204</var> waits after completing a display before beginning the next display.</td>
<td>The number of seconds <var class="product">Model&nbsp;204</var> waits after completing a display before beginning the next display.</td>
</tr>
</tr>
   
   
<tr>
<tr>
<th><var>SERV</var></th>
<th><var>SERV</var></th>
<td> specifies to display server information about the Online. See the MONITOR SERV command as documented in [[MONITOR command: SERVSIZE, LSERVER and server number|MONITOR: SERVSIZE, LSERVER and server number]].</td>
<td>Displays server information about the Online. See the <var>MONITOR SERV</var> command as documented in [[MONITOR command: SERVSIZE, LSERVER and server number|MONITOR: SERVSIZE, LSERVER and server number]].</td>
</tr>
</tr>
</table>
</table>
==Examples==
==Examples==
<p class="code">MONITOR CHECKPOINT
<p class="code">MONITOR CHECKPOINT
Line 49: Line 49:
MONITOR SUBTRAN USERLIST SL SERV
MONITOR SUBTRAN USERLIST SL SERV
</p>
</p>
==Usage notes==
==Usage notes==
====Monitoring transaction checkpoints====
====Monitoring transaction checkpoints====
<p>A MONITOR CHECKPOINT command displays the following type of transaction information: </p>
<p>
<p class="code">*** M204.2073: LAST SUCCESSFUL CHECKPOINT COMPLETED ON yy.ddd hh:mm:ss.th
A <code>MONITOR CHECKPOINT</code> command displays the following type of transaction information: </p>
<b></b>*** M204.2074: n CHECKPOINTS HAVE SINCE TIMED OUT
 
<b></b>*** M204.2075: n RECORDS CURRENTLY IN CHKPOINT STREAM
<p class="code">*** M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT: <i>yy.ddd hh:mm:ss.th</i>
<b></b>*** M204.2076: n CHECKPOINTS CURRENTLY IN CHKPOINT STREAM
<b></b>*** M204.2074: <i>n</i> CHECKPOINTS HAVE SINCE TIMED OUT
<b></b>*** M204.2077: n USERS CURRENTLY HAVE CHECKPOINTS INHIBITED
<b></b>*** M204.2075: <i>n</i> RECORDS CURRENTLY IN ACTIVE CHKPOINT STREAM
</p>
<b></b>*** M204.2076: <i>n</i> CHECKPOINTS CURRENTLY IN CHKPOINT STREAM
<p>A MONITOR CHECKPOINT USERLIST command displays a basic user line for every user that currently inhibits checkpoints. The following type of transaction information is displayed, where the basic MONITOR display is given for only those users currently inhibiting checkpoints: </p>
<b></b>*** M204.2077: <i>n</i> USERS CURRENTLY INHIBITING CHECKPOINTS  
<p class="code">*** M204.2073: LAST SUCCESSFUL CHECKPOINT COMPLETED AT yy.ddd hh:mm:ss.th
<b></b>*** M204.2692: <i>n</i> IS HIGHEST NUMBER OF CHKP RECORDS</p>
<b></b>*** M204.2074: n CHECKPOINTS HAVE SINCE TIMED OUT
<p>
<b></b>*** M204.2075: n RECORDS CURRENTLY IN CHKPOINT STREAM
A <code>MONITOR CHECKPOINT USERLIST</code> command displays a basic user line for every user that currently inhibits checkpoints. The following type of transaction information is displayed, where the basic <var>MONITOR</var> display is given for only those users currently inhibiting checkpoints: </p>
<b></b>*** M204.2076: n CHECKPOINTS CURRENTLY IN CHKPOINT STREAM
 
<b></b>*** M204.2077: n USERS CURRENTLY HAVE CHECKPOINTS INHIBITED
<p class="code">*** M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT <i>yy.ddd hh:mm:ss.th</i>
<b></b>*** M204.2074: <i>n</i> CHECKPOINTS HAVE SINCE TIMED OUT
<b></b>*** M204.2075: <i>n</i> RECORDS CURRENTLY IN ACTIVE CHKPOINT STREAM
<b></b>*** M204.2076: <i>n</i> CHECKPOINTS CURRENTLY IN CHKPOINT STREAM
<b></b>*** M204.2077: <i>n</i> USERS CURRENTLY INHIBITING CHECKPOINTS
<b></b>*** M204.2692: <i>n</i> IS HIGHEST NUMBER OF CHKP RECORDS
<b></b>*** M204.2078: USERS CURRENTLY INHIBITING CHECKPOINTS ARE:
<b></b>*** M204.2078: USERS CURRENTLY INHIBITING CHECKPOINTS ARE:
USER SVR USERID P  CUR SLICE AGE FUNC CNCT CPU    SEQIO  QUE  WT  FL
USER SVR USERID P  CUR SLICE AGE FUNC CNCT CPU    SEQIO  QUE  WT  FL
nn    n  xxxx  n  nn  n.nnn  n  xxxx  nnn n.nn    n  xxxx  nn  nn
<i>nn    n  xxxx  n  nn  n.nnn  n  xxxx  nnn n.nn    n  xxxx  nn  nn</i>
</p>
</p>
====Monitoring sub-transaction checkpoints====
====Monitoring sub-transaction checkpoints====
<p>A MONITOR SUBTRAN command displays the sub-transaction checkpoints followed by transaction checkpoint information, similar to the following:</p>
<p>
<p class="code">SUB-TRANSACTION check pointing STATUS:
A <code>MONITOR SUBTRAN</code> command displays the sub-transaction checkpoints followed by transaction checkpoint information, similar to the following:</p>
 
<p class="code">SUB-TRANSACTION CHECKPOINTING STATUS:
DDNAME  SUBTU DRTYF  RECS RECHWM DRTYBU DRTYFT  CDRPGS CDCPGS BLOGPGS  BLOGFT
DDNAME  SUBTU DRTYF  RECS RECHWM DRTYBU DRTYFT  CDRPGS CDCPGS BLOGPGS  BLOGFT
------  ----- ----- ------ ------ ------ ------  ------ ------ -------  ------
&#45;-----  ----- ----- ------ ------ ------ ------  ------ ------ -------  ------
CHKPOINT    0    0      0      0      0      0      0      0      0      0
CHKPOINT    0    0      0      0      0      0      0      0      0      0
CHKPNTS      0    0      0      0      0      0      0      0      0      0
CHKPNTS      0    0      0      0      0      0      0      0      0      0
Line 81: Line 91:
<b></b>***  M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT:  05.004  00:46:22.79
<b></b>***  M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT:  05.004  00:46:22.79
<b></b>***  M204.2074: 0 CHECKPOINTS HAVE SINCE TIMED OUT
<b></b>***  M204.2074: 0 CHECKPOINTS HAVE SINCE TIMED OUT
<b></b>***  M204.2075: 1 RECORDS CURRENTLY IN CHKPOINT STREAM
<b></b>***  M204.2075: 1 RECORDS CURRENTLY IN CHKPOINT STREAM
<b></b>***  M204.2075: 1 RECORDS CURRENTLY IN CHKPOINT STREAM
<b></b>***  M204.2692: 1007 IS MAXIMUM NUMBER OF CHKPOINT RECORDS
<b></b>***  M204.2692: 1007 IS MAXIMUM NUMBER OF CHKPOINT RECORDS
</p>
</p>
<p>Where:</p>
<p>
<p>*DDNAME specifies the ddname associated with stream, CHKPOINT or CHKPNTS, (*indicates the active ddname) and:</p>
Where:</p>
<p>
<code>*DDNAME</code> specifies the DDname associated with stream, <code>CHKPOINT</code> or <code>CHKPNTS</code>, (<tt>*</tt> indicates the active DDname) and:</p>
<table>
<table>
    
    
<tr> <th>
<tr class="head"> <th><p>Count</p></th>  
<p>Count</p>
<th><p> Specifies number of...</p></th> </tr>
</th> <th>
<p> Specifies number of...</p>
</th> </tr>
    
    
<tr> <th><var>
<tr> <th><var><p>SUBTU </p></var></th>  
<p>SUBTU </p>
<td><p>Sub-transaction updaters</p></td> </tr>
</var></th> <td>
<p>Sub-transaction updaters</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>DRTYF </p></var></th>  
<p>DRTYF </p>
<td><p>Dirty files participating in sub-trans checkpoints </p></td> </tr>
</var></th> <td>
<p>Dirty files participating in sub-trans checkpoints </p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>RECS </p></var></th>  
<p>RECS </p>
<td><p>6184-byte records in ddname</p></td> </tr>
</var></th> <td>
<p>6184-byte records in ddname</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>RECHWM </p></var></th>  
<p>RECHWM </p>
<td><p>6184-byte records written to the stream: the high-water mark</p></td> </tr>
</var></th> <td>
<p>6184-byte records written to the stream: the high-water mark</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>DRTYBU </p></var></th>  
<p>DRTYBU </p>
<td><p>Dirty buffers flushed (written) back to files</p></td> </tr>
</var></th> <td>
<p>Dirty buffers flushed (written) back to files</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>DRTYFT </p></var></th>  
<p>DRTYFT </p>
<td><p>Milliseconds of elapsed time required to flush the buffers </p></td> </tr>
</var></th> <td>
<p>Milliseconds of elapsed time required to flush the buffers </p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>CDRPGS </p></var></th>  
<p>CDRPGS </p>
<td><p>Real (in-memory) constraints database pages written</p></td> </tr>
</var></th> <td>
<p>Real (in-memory) constraints database pages written</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>CDCPGS </p></var></th>  
<p>CDCPGS </p>
<td><p>CCATEMP - constraints database pages written </p></td> </tr>
</var></th> <td>
<p>CCATEMP - constraints database pages written </p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>BLOGPGS </p></var></th>  
<p>BLOGPGS </p>
<td><p>Back out log pages copied </p></td> </tr>
</var></th> <td>
<p>Back out log pages copied </p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var><p>BLOGFT </p></var></th>  
<p>BLOGFT </p>
<td><p>Milliseconds of elapsed time required to copy back out log pages </p></td> </tr>  
</var></th> <td>
<p>Milliseconds of elapsed time required to copy back out log pages </p>
</td> </tr>
 
</table>
</table>
<p>The MONITOR SUBTRAN command can be expanded to the following forms to provide the previous display plus information on all users inhibiting transaction checkpoints: </p>
 
<p>
The <code>MONITOR SUBTRAN</code> command can be expanded to the following forms to provide the previous display plus information on all users inhibiting transaction checkpoints: </p>
<p class="code">MONITOR SUBTRAN USERLIST  
<p class="code">MONITOR SUBTRAN USERLIST  
MONITOR SUBTRAN USERLIST SL  
MONITOR SUBTRAN USERLIST SL  
MONITOR SUBTRAN USERLIST SL SERV
MONITOR SUBTRAN USERLIST SL SERV
</p>
</p>
<p>For more information about the contents of the basic MONITOR display and transaction and sub-transaction checkpoints, see the <var>Model&nbsp;204 System Manager's Guide</var>. </p>
<p>
For more information about the contents of the basic <var>MONITOR</var> display and transaction and sub-transaction checkpoints, see [[Controlling system operations (CCAIN)#ONLINE monitoring|ONLINE monitoring]] and [[Checkpoints: Storing before-images of changed pages]]. </p>
 
[[Category: System administrator commands]]
[[Category: System administrator commands]]
[[Category:Commands]]
[[Category:Commands]]

Latest revision as of 17:39, 17 November 2014

Summary

Privileges
System administrator
Function
Enables system administrators to verify the date and time of the last successful checkpoint. Other valuable information, such as the number of timeouts since the successful checkpoint, the number of users preventing checkpoints, and the current size of CHKPOINT, can be displayed.

Syntax

MONITOR {CHECKPOINT | CHKP | SUBTRAN} [USERLIST] [SL] [EVERY n] [SERV]

Where:

CHECKPOINT Causes basic informational messages for transaction checkpoints to appear. CHKP is the abbreviation for CHECKPOINT.
SUBTRAN Causes basic information messages for sub-transaction checkpoints as well as transaction checkpoints to appear.
USERLIST Causes the basic user line to appear for every user who inhibits checkpoints.
SL Displays the since last statistics.
EVERY n The number of seconds Model 204 waits after completing a display before beginning the next display.
SERV Displays server information about the Online. See the MONITOR SERV command as documented in MONITOR: SERVSIZE, LSERVER and server number.

Examples

MONITOR CHECKPOINT MONITOR CHKP USERLIST EVERY 30 MONITOR SUBTRAN USERLIST SL SERV

Usage notes

Monitoring transaction checkpoints

A MONITOR CHECKPOINT command displays the following type of transaction information:

*** M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT: yy.ddd hh:mm:ss.th *** M204.2074: n CHECKPOINTS HAVE SINCE TIMED OUT *** M204.2075: n RECORDS CURRENTLY IN ACTIVE CHKPOINT STREAM *** M204.2076: n CHECKPOINTS CURRENTLY IN CHKPOINT STREAM *** M204.2077: n USERS CURRENTLY INHIBITING CHECKPOINTS *** M204.2692: n IS HIGHEST NUMBER OF CHKP RECORDS

A MONITOR CHECKPOINT USERLIST command displays a basic user line for every user that currently inhibits checkpoints. The following type of transaction information is displayed, where the basic MONITOR display is given for only those users currently inhibiting checkpoints:

*** M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT yy.ddd hh:mm:ss.th *** M204.2074: n CHECKPOINTS HAVE SINCE TIMED OUT *** M204.2075: n RECORDS CURRENTLY IN ACTIVE CHKPOINT STREAM *** M204.2076: n CHECKPOINTS CURRENTLY IN CHKPOINT STREAM *** M204.2077: n USERS CURRENTLY INHIBITING CHECKPOINTS *** M204.2692: n IS HIGHEST NUMBER OF CHKP RECORDS *** M204.2078: USERS CURRENTLY INHIBITING CHECKPOINTS ARE: USER SVR USERID P CUR SLICE AGE FUNC CNCT CPU SEQIO QUE WT FL nn n xxxx n nn n.nnn n xxxx nnn n.nn n xxxx nn nn

Monitoring sub-transaction checkpoints

A MONITOR SUBTRAN command displays the sub-transaction checkpoints followed by transaction checkpoint information, similar to the following:

SUB-TRANSACTION CHECKPOINTING STATUS: DDNAME SUBTU DRTYF RECS RECHWM DRTYBU DRTYFT CDRPGS CDCPGS BLOGPGS BLOGFT ------ ----- ----- ------ ------ ------ ------ ------ ------ ------- ------ CHKPOINT 0 0 0 0 0 0 0 0 0 0 CHKPNTS 0 0 0 0 0 0 0 0 0 0 *** M204.2697: START OF SUB-TRANS CHKP AT: 00.000 00:00:00.00, CHKPOINT *** M204.2698: END OF SUB-TRANS CHKP AT: 00.000 00:00:00.00, CHKPOINT *** M204.2697: START OF SUB-TRANS CHKP AT: 00.000 00:00:00.00, CHKPNTS *** M204.2698: END OF SUB-TRANS CHKP AT: 00.000 00:00:00.00, CHKPNTS *** M204.2073: LATEST SUCCESSFUL CHECKPOINT COMPLETED AT: 05.004 00:46:22.79 *** M204.2074: 0 CHECKPOINTS HAVE SINCE TIMED OUT *** M204.2075: 1 RECORDS CURRENTLY IN CHKPOINT STREAM *** M204.2692: 1007 IS MAXIMUM NUMBER OF CHKPOINT RECORDS

Where:

*DDNAME specifies the DDname associated with stream, CHKPOINT or CHKPNTS, (* indicates the active DDname) and:

Count

Specifies number of...

SUBTU

Sub-transaction updaters

DRTYF

Dirty files participating in sub-trans checkpoints

RECS

6184-byte records in ddname

RECHWM

6184-byte records written to the stream: the high-water mark

DRTYBU

Dirty buffers flushed (written) back to files

DRTYFT

Milliseconds of elapsed time required to flush the buffers

CDRPGS

Real (in-memory) constraints database pages written

CDCPGS

CCATEMP - constraints database pages written

BLOGPGS

Back out log pages copied

BLOGFT

Milliseconds of elapsed time required to copy back out log pages

The MONITOR SUBTRAN command can be expanded to the following forms to provide the previous display plus information on all users inhibiting transaction checkpoints:

MONITOR SUBTRAN USERLIST MONITOR SUBTRAN USERLIST SL MONITOR SUBTRAN USERLIST SL SERV

For more information about the contents of the basic MONITOR display and transaction and sub-transaction checkpoints, see ONLINE monitoring and Checkpoints: Storing before-images of changed pages.

Retrieved from "https://m204wiki.rocketsoftware.com/index.php?title=MONITOR_command:_Checkpoints-transaction_and_sub-transaction&oldid=73342"