Example of a Drop Recovery report

As part of an automated drop recovery work ID, you can request a Drop Recovery report that provides summarized information about the objects to recover.

The following figure shows an example of a Drop Recovery report. For more information about how to define this report, see Generating-drop-recovery-output.

Related topic

Overview-of-automated-drop-recovery

 Date: 2022-08-18            BMC AMI Log Master for Db2 -  V13.01.00        Page:       1
 Time: 10.04.20         Copyright BMC Software, Inc. 1995-2023

                               Drop Recovery Report
 --------------------------------------------------------------------------------

 From: Mark DB2DBA.START.RANGE(0)                            (x'C32FD42FBBA2')
   To: Mark DB2DBA.END.RANGE(0)                              (x'C32FD44B2E65')

 --------------------------------------------------------------------------------
 Report Information:

 Work ID    : DB2DBA.$$WORKID0001         Run Number:    3  Subsystem: DXW2
 Description: DB2DBA AUTOMATED DROP RECOVERY--TABLE SPACE
 --------------------------------------------------------------------------------
 Dropped Object: Tablespace: DB2DBADB.DB2DBAS1           OLD ObIDs   New ObIDs
     Drop RBA/LRSN: X'C32FD441E5AE'
     Tablespace Name: DB2DBADB.DB2DBAS1                  363.2       363.7
         Status: No Errors

         Table Name: DB2DBADB.DB2DBAB1                   363.3       363.8
             Index Name: DB2DBADB.DB2DBAI1
             Index Name: DB2DBADB.DB2DBAI2

         Table Name: DB2DBADB.DB2DBAB9                   363.8       363.13
             Index Name: DB2DBADB.DB2DBAI9
             Index Name: DB2DBADB.DB2DBAI8

         Resources for recovery:
             Full Copy: RBA/LRSN: X'C32FD43EC858'
                     Timestamp: 2022-08-18-10.04.05.198276
                     DSN      : DB2DBA.DB2DBA.TS1.FCOPY1
                     Shrlevel : Reference
                     Type     : Local Primary            Dsnum  : 0
                     File Seq : 0                        DevType: 3390


 Dropped Object: Tablespace: DB2DBADB.DB2DBAS2           OLD ObIDs   New ObIDs
     Drop RBA/LRSN: X'C32FD441E5AE'
     Tablespace Name: DB2DBADB.DB2DBAS2                  363.14      363.2
         Status: No Errors

         Table Name: DB2DBADB.DB2DBAB2                   363.15      363.3
             Index Name: DB2DBADB.DB2DBAI3

         Resources for recovery:
             Full Copy: RBA/LRSN: X'C32FD43FA815'
                     Timestamp: 2022-08-18-10.04.06.116852
                     DSN      : DB2DBA.DB2DBA.TS2.FCOPY1
                     Shrlevel : Reference
                     Type     : Local Primary            Dsnum  : 0
                     File Seq : 0                        DevType: 3390

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*