STATUS command: Listing file recovery information

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.