STATUS command: Listing file recovery information: Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (remove Sys Man guide)
Line 6: Line 6:
<dd>Lists recovery information about one or more files
<dd>Lists recovery information about one or more files
</dl>
</dl>
==Syntax==
==Syntax==
<p class="syntax">STATUS <i>filename</i>
<p class="syntax">STATUS <span class="term">filename</span>
</p>
</p>
   
   
<b>Where:</b>
Where <var class="term">filename</var> is the name of a <var class="product">Model&nbsp;204</var> file that was opened during the run (by a user or a <var>RESTART</var> command). If the file name is omitted, status information is listed for all files opened during the run.
filename is the name of a <var class="product">Model&nbsp;204</var> file that was opened during the run (by a user or a RESTART command). If the file name is omitted, status information is listed for all files opened during the run.
 
==Example==
==Example==
STATUS CENSUS  
<p class="code">STATUS CENSUS</p>
 
==Usage notes==
==Usage notes==
<p>If you issue a USE command prior to issuing STATUS, all output from the STATUS command is routed to the USE data set or printer. The USE device is closed when the STATUS command concludes.</p>
<p>
<p>The STATUS command displays recovery information about a specified file or about all the files opened during the run.</p>
If you issue a <var>USE</var> command prior to issuing <var>STATUS</var>, all output from the <var>STATUS</var> command is routed to the USE data set or printer. The <var>USE</var> device is closed when the <var>STATUS</var> command concludes.</p>
<p>One or two lines of information are listed for each file, in the form: </p>
<p>
<p class="code"><i>filename: current-status
The <var>STATUS</var> command displays recovery information about a specified file or about all the files opened during the run.</p>
           RESTART-status</i>
<p>
One or two lines of information are listed for each file, in the form: </p>
<p class="code"><i>filename: current-status </i>
           <i>RESTART-status</i>
</p>
</p>
   
   
<b>Where:</b>
Where:
<table>  
<table>  
<tr>
<tr>
<th nowrap>current-status</th>
<th nowrap>current-status</th>
<td> indicates special conditions that can affect discontinuities and future recovery of the file. current-status values are shown in the table below.
<td>Special conditions that can affect discontinuities and future recovery of the file. <var class="term">current-status</var> values are shown in the table below.
<table>
<table>
<caption>STATUS command current
<caption>STATUS command current
status conditions </caption>
status conditions </caption>
      
      
<tr> <th>
<tr class="head"> <th><p>Value</p></th>  
<p>Value</p>
<th><p>The file is...</p></th> </tr>
</th> <th>
<p>The file is...</p>
</th> </tr>
    
    
<tr> <th><var>
<tr> <th><var><p>CLOSED</p></var></th>  
<p>CLOSED</p>
<td><p>Not currently open by any user.</p></td> </tr>
</var></th> <td>
<p>Not currently open by any user.</p>
</td> </tr>
   
   
<tr> <th><var>
<tr> <th><var>
Line 65: Line 64:
</var></th> <td>
</var></th> <td>
<p>Up-to-date since the beginning of the run. If ENQUEUED or OPEN is not also shown, a discontinuity can be produced by another updating <var class="product">Model&nbsp;204</var> job. </p>
<p>Up-to-date since the beginning of the run. If ENQUEUED or OPEN is not also shown, a discontinuity can be produced by another updating <var class="product">Model&nbsp;204</var> job. </p>
</td> </tr>
</td> </tr>  
 
</table>
</table>
</td>
</td></tr>
</tr>
   
   
<tr>
<tr>
<th nowrap><var>RESTART-status</var></th>
<th nowrap>RESTART-status</th>
<td> appears only for a file that participated in recovery in the current run. The values of RESTART-status are shown in the following table. The checkpoint facility is detailed in the <var>Model&nbsp;204 System Manager's Guide</var>
<td> appears only for a file that participated in recovery in the current run. The values of RESTART-status are shown in the following table. The checkpoint facility is described in [[Checkpoints: Storing before-images of changed pages]].
 
<table>
<table>
<caption>STATUS command RESTART status </caption>
<caption>STATUS command RESTART status </caption>
   
<tr class="head">  
<tr> <th>
<th><p>Value</p></th>  
<p>Value</p>
<th><p>Meaning</p></th> </tr>
</th> <th>
<p>Meaning</p>
</th> </tr>
    
    
<tr> <th><var>
<tr> <th nowrap><var><p>BEING RECOVERED</p></var></th>  
<p>BEING RECOVERED</p>
<td><p>The file is in the process of being recovered when the STATUS command is issued. The file cannot be opened until the RESTART command finishes.</p></td> </tr>
</var></th> <td>
<p>The file is in the process of being recovered when the STATUS command is issued. The file cannot be opened until the RESTART command finishes.</p>
</td> </tr>
<tr> <th><var>
<p>NOT RECOVERED</p>
</var></th> <td>
<p>Reason, where reason is one of the following:</p>
<p>DEFERRED UPDATE CHKP MISSING The scan of the deferred update data set did not locate the checkpoint being used for rollback.</p>
<p>DEFERRED UPDATE READ ERROR The scan of the deferred update data set could not be completed because of a read error.</p>
<p>DEFERRED UPDATES MISSING The deferred update data set could not be opened.</p>
<p>MISSING The file could not be opened.</p>
<p>OBSOLETE The file was updated by a <var class="product">Model&nbsp;204</var> job after the last update in the run being recovered. </p>
<p>ROLLED BACK TO CHECKPOINT OF yy.ddd hh:mm:ss.th.  The file was rolled back to the checkpoint that was taken at the given date and time. The file was not rolled forward.    </p>
<p>ROLLED BACK TO DISCONTINUITY yy.ddd hh:mm:ss.th.  The file was rolled back to a discontinuity that occurred at the given date and time. The file was not rolled forward. </p>
<p>ROLLED FORWARD TO UPDATE ID n OF yy.ddd hh:mm:ss.th. The file was first rolled back and then rolled forward. The last update unit reapplied by ROLL FORWARD had the given ID. </p>
</td> </tr>
 
</table>
</td>
</tr>
   
   
<tr> <th><var><p>NOT RECOVERED</p></var></th>
<td><p>Reason, where reason is one of the following:</p>
<dl>
<dt>DEFERRED UPDATE CHKP MISSING </dt>
<dd>The scan of the deferred update data set did not locate the checkpoint being used for rollback.</dd>
<dt>DEFERRED UPDATE READ ERROR </dt>
<dd>The scan of the deferred update data set could not be completed because of a read error.</dd>
<dt>DEFERRED UPDATES MISSING</dt>
<dd>The deferred update data set could not be opened.</dd>
<dt>MISSING</dt>
<dd>The file could not be opened.</dd>
<dt>OBSOLETE</dt>
<dd>The file was updated by a <var class="product">Model&nbsp;204</var> job after the last update in the run being recovered. </dd>
<dt>ROLLED BACK TO CHECKPOINT OF yy.ddd hh:mm:ss.th</dt> 
<dd>The file was rolled back to the checkpoint that was taken at the given date and time. The file was not rolled forward. </dd>
<dt>ROLLED BACK TO DISCONTINUITY yy.ddd hh:mm:ss.th </dt> 
<dd>The file was rolled back to a discontinuity that occurred at the given date and time. The file was not rolled forward. </dd>
<dt>ROLLED FORWARD TO UPDATE ID n OF yy.ddd hh:mm:ss.th</dt>
<dd>The file was first rolled back and then rolled forward. The last update unit reapplied by ROLL FORWARD had the given ID. </dd>
</dl></td> </tr> 
</table></td></tr>
</table>
</table>
<p>When running Parallel Query Option/204 for client users with open remote files, the display includes the following information: </p>
<p>  
<p class="code">filename: status (REMOTE FILE), LOCATION: name1 ONLINE: name2
When running Parallel Query Option/204 for client users with open remote files, the display includes the following information: </p>
<p class="syntax"><span class="term">filename</span>: <span class="term">status</span> (REMOTE FILE), LOCATION: <span class="term">name1</span> ONLINE: <span class="term">name2</span>
</p>
</p>
<p>where: </p>
<p>Where: </p>
<ul>  
<ul>  
<li>
<li><var class="term">filename</var> is the actual (non-synonym) name of the remote file.</li>
<p>filename is the actual (non-synonym) name of the remote file.</p>
</li>
   
   
<li>
<li><var class="term">status</var> is one of the values shown above in the [[#Usage notes|"STATUS command current status conditions" table]].
<p>status is one of the values shown in #STATUSLISTINGFILERECOVERYINFORMATIO-839B33FF/M204_REF_STATUSLISTRECOVERY_TABLE1</p>
<p class="note"><b>Note:</b> Parallel Query Option status shows only the open files that are being run locally, not remote files.</p></li>
<p class="note"><b>Note:</b> Parallel Query Option status shows only the open files that are being run locally, not remote files.</p>
</li>
   
   
<li>
<li><var class="term">name1</var> is the symbolic name of the file's remote location as specified in the <var>DESTINATION</var> parameter of a local <var>DEFINE PROCESS</var> command. </li>
<p>name1 is the symbolic name of the file's remote location as specified in the DESTINATION parameter of a local DEFINE PROCESS command. </p>
</li>
   
   
<li>
<li><var class="term">name2</var> is the value of the CCAIN parameter <var>LOCATION</var> in the server Online.</li>
<p>name2 is the value of the CCAIN parameter LOCATION in the server Online. </p>
</ul>
</li>
 
</ul>
[[Category: System administrator commands]]
[[Category: System administrator commands]]
[[Category: System manager commands]]
[[Category: System manager commands]]
[[Category: General user commands]]
[[Category: General user commands]]
[[Category:Commands]]
[[Category:Commands]]

Revision as of 19:22, 31 October 2014

Summary

Privileges
Any user (only the system manager or the system administrator can list information about all files)
Function
Lists recovery information about one or more files

Syntax

STATUS filename

Where filename is the name of a Model 204 file that was opened during the run (by a user or a RESTART command). If the file name is omitted, status information is listed for all files opened during the run.

Example

STATUS CENSUS

Usage notes

If you issue a USE command prior to issuing STATUS, all output from the STATUS command is routed to the USE data set or printer. The USE device is closed when the STATUS command concludes.

The STATUS command displays recovery information about a specified file or about all the files opened during the run.

One or two lines of information are listed for each file, in the form:

filename: current-status RESTART-status

Where:

current-status Special conditions that can affect discontinuities and future recovery of the file. current-status values are shown in the table below.
STATUS command current status conditions

Value

The file is...

CLOSED

Not currently open by any user.

DEFERRED

In deferred update mode in the current run and will not be closed until the end of the run.

ENQUEUED

Enqueued with either share or exclusive status. If CLOSED also appears, the file is enqueued in share status to prevent discontinuities.

OPEN

Currently open by one or more users (or the file is in deferred update mode).

UPDATED

Up-to-date since the beginning of the run. If ENQUEUED or OPEN is not also shown, a discontinuity can be produced by another updating Model 204 job.

RESTART-status appears only for a file that participated in recovery in the current run. The values of RESTART-status are shown in the following table. The checkpoint facility is described in Checkpoints: Storing before-images of changed pages.
STATUS command RESTART status

Value

Meaning

BEING RECOVERED

The file is in the process of being recovered when the STATUS command is issued. The file cannot be opened until the RESTART command finishes.

NOT RECOVERED

Reason, where reason is one of the following:

DEFERRED UPDATE CHKP MISSING
The scan of the deferred update data set did not locate the checkpoint being used for rollback.
DEFERRED UPDATE READ ERROR
The scan of the deferred update data set could not be completed because of a read error.
DEFERRED UPDATES MISSING
The deferred update data set could not be opened.
MISSING
The file could not be opened.
OBSOLETE
The file was updated by a Model 204 job after the last update in the run being recovered.
ROLLED BACK TO CHECKPOINT OF yy.ddd hh:mm:ss.th
The file was rolled back to the checkpoint that was taken at the given date and time. The file was not rolled forward.
ROLLED BACK TO DISCONTINUITY yy.ddd hh:mm:ss.th
The file was rolled back to a discontinuity that occurred at the given date and time. The file was not rolled forward.
ROLLED FORWARD TO UPDATE ID n OF yy.ddd hh:mm:ss.th
The file was first rolled back and then rolled forward. The last update unit reapplied by ROLL FORWARD had the given ID.

When running Parallel Query Option/204 for client users with open remote files, the display includes the following information:

filename: status (REMOTE FILE), LOCATION: name1 ONLINE: name2

Where:

  • filename is the actual (non-synonym) name of the remote file.
  • status is one of the values shown above in the "STATUS command current status conditions" table.

    Note: Parallel Query Option status shows only the open files that are being run locally, not remote files.

  • name1 is the symbolic name of the file's remote location as specified in the DESTINATION parameter of a local DEFINE PROCESS command.
  • name2 is the value of the CCAIN parameter LOCATION in the server Online.