The REPORT RECOVERY Utility

The REPORT RECOVERY Utility

The REPORT RECOVERY utility is the second type of REPORT utility provided by DB2. It can be used to generate a report on table space or index recovery information. The report contains information from the DB2 Directory, the DB2 Catalog, and the BSDS. The input to the utility is either a table space, a single partition of a partitioned table space, or an index.

REPORT RECOVERY has several options, including the following:

• Providing recovery information to the last recoverable point, which is the last execution of a full image copy, LOAD REPLACE LOG YES , or REORG LOG YES

• Providing all recovery information for a table space (or index), not just information to the last recoverable point

• Providing a list of volume serial numbers for the image copy data sets and archive log data sets needed for recovery

The output of REPORT RECOVERY is a report of all related DB2 recovery information, including image copy information, log RBA information, and archive log information needed to recover the requested table space (or index).

The sample JCL in Listing 32.10 produces a report up to the last recoverable point for the sample table space DSN8D81A.DSN8S81C .

Listing 32.10. REPORT RECOVERY JCL

 //DB2JOBU  JOB  (UTILITY),'DB2 REPRT RCVRY',MSGCLASS=X,CLASS=X, //          NOTIFY=USER //* //**************************************************************** //* //*         DB2 REPORT RECOVERY UTILITY //* //**************************************************************** //* //UTIL EXEC DSNUPROC,SYSTEM=DB2T,UID='REPORTRC',UTPROC=" //DSNUPROC.SYSIN    DD  *     REPORT RECOVERY TABLESPACE DSN8D81A.DSN8S81E /* // 

REPORT RECOVERY Locking Considerations

The REPORT utility is compatible with all other utilities. It functions like any other process that reads DB2 data.

REPORT RECOVERY Guideline

The REPORT RECOVERY utility can be used to determine which data sets will be needed by the RECOVERY utility before recovering a table space. This can be useful when you must determine whether the requisite data sets are still cataloged or available.