RECOVER preparation
Before you run RECOVER on a table space or index space, determine the name of the page set and the number of the page that is involved in the data or index inconsistency.
To prepare to run RECOVER, use the most convenient of the following procedures:
- Review the DSNIxxxx messages you received.
The format of the
NAMEcategory isDB.SP.PG- where
DB= database name
If the database name of the inconsistent resource is DSNDB01 (directory) or DSNDB06 (catalog), there can be inconsistency problems in the hash chains in the directory or catalog, and subsequent DDL activity can cause more damage. Before proceeding, stop further DDL activity by issuing the following command:
-START DATABASE (DSNDB06) ACCESS (RO) - Another way to find the page number of the damaged page is to locate register 8 at offset X'38' in the system diagnostic work area (SDWA) of the SVC dump that is issued for the abend. The SDWA is at the beginning of the dump. Register 8 contains the address of the buffer manager (BM) block. At offset X'10' in that block is the 3-byte hexadecimal number of the inconsistent page.
- A third method for determining the number of the damaged page
and the name of a damaged page set is to locate either the variable
recording area (VRA) or the VRA diagnostic information report. In
an SVC dump, the VRA begins at offset X'190' in the SDWA.
The VRA diagnostic information report is at the beginning of the formatted
section of the dump. The page number in the dump where the formatted
section begins can be found as the last entry of Print Dump Index
or Table of Contents in the dump (indexed by "Formatted From
DSNWDMP").
In the VRA, offset X'02' contains the type code. If the type code is 302, the damaged page is a data page; a type code of 301 or 303 indicates an index subpage or index page. Offset X'16' of the VRA contains the number of the damaged page and offset X'0B' contains the name of the page set involved in the inconsistency.
In the VRA diagnostic information report, this information is associated with the following keys:
- X'D6'
- The field name is VRARRK14; it contains the type code.
- X'D7'
- The field name is VRARRK15; it contains the name of the resource that is inconsistent. The page number is at offset X'14' and the page set name is at offset X'09' of this field.
To determine which pages in a table space are logically in error, issue the command
-DISPLAY DATABASE(database-name) SPACENAM(ts-name) LPL