Previous Topic: Example 2Next Topic: REMOVE (Remove Key ID)


Sample Report: RECOVERY

Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ RECBASE DBID=1 FUNCTION=RECBASE  DBID=00001 Ž

Date: mm/dd/ccyy ******************************************************************************** Page: 2 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** CONTROL CARD(S) .........1.........2.........3.........4.........5.........6.........7.........8 Œ RECOVERY OPTION=FORWARD FUNCTION=RECOVERY  OPTION=FORWARD Ž

Œ

The command exactly as entered.



An analysis of keywords encountered and expected. Any errors found are flagged with a note in the left margin.

Ž

Any messages related to syntax processing.

Date: mm/dd/ccyy ******************************************************************************** Page: 3 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Directory: PRODCXX DATACOM/DB RECOVERY   JOB NAME R-UNIT DATE TIME REQUEST BASE BLOCK URI AREA RM START OF RECORD ERROR MESSAGES DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000B EMP 00011IH000100000000000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000C EMP 00012AS000500000104000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000D EMP 00013AH000110000104000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000E EMP 00014AS000500000104000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000F EMP 00015AS000500000104000



The name of the job being recovered.



The run unit of the job.

The date the record was logged.

The time the record was logged.

The contents of the request area.

The database ID.

The block number in hex.

(page 3 continued)

Date: mm/dd/ccyy ******************************************************************************** Page: 3 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Directory: PRODCXX DATACOM/DB RECOVERY Œ  Ž  JOB NAME R-UNIT DATE TIME REQUEST BASE BLOCK URI AREA RM START OF RECORD ERROR MESSAGES DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000B EMP 00011IH000100000000000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000C EMP 00012AS000500000104000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000D EMP 00013AH000110000104000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000E EMP 00014AS000500000104000 DBL2EPAY 23,067 10/03/2003 14.24.48 UPDATPAY 1 00000002 0000000F EMP 00015AS000500000104000

Œ

The Unique Row Identifier (URI) number in hex. For non-URI areas, the logical record number within the block in hex.



Contains the area that contains the table of the maintenance command. If the table is a Full Parent partitioned table or an Any partitioned table, the area is the specific area in which the record resides.

Ž

The R field contains an R if the log record has been rolled backward by transaction backout. It does not contain an R if the request was part of transaction backout but was actually done by a backward recovery in support of RXXROLLBACK. The R field is informational and requires no action.



The M field contains an M if the log record represents a record that has been moved from one block to another. This normally only occurs for a compressed table where the record after an UPDAT does not fit back in the same block and is therefore moved to another block. The M field is informational and requires no action.



The first 20 bytes of the user work area.

The error messages produced during recovery.

The page containing the following fields is produced only when you specify a RECJOB command. The fields contain values only when the job specified in the command is found in the Recovery File.

Date: mm/dd/ccyy ******************************************************************************** Page: 4 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** DATACOM/DB RECOVERY JOBS NOT FOUND ON RECOVERY FILE Œ  Ž   JOB NAME DATE START TIME STOP TIME RUN UNIT

Œ

The job name of the job for which recovery was requested.



The date of the job to be recovered.

Ž

The start time for the recovery.



The ending time for the recovery.



The run unit assigned to the job to be recovered.

The page containing the following fields is produced for all jobs.

Date: mm/dd/ccyy ******************************************************************************** Page: 5 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** ERROR SUMMARY Œ TOTAL ERRORS ENCOUNTERED-----0 FIRST 01 PAGE(S) CONTAINING ERROR(S)-----4 LAST ERROR ON PAGE -----4

Œ

A summary of the errors encountered.