Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Log Master for Db2 13.1.

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.

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

                               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: 2020-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: 2020-08-18-10.04.06.116852
                     DSN      : DB2DBA.DB2DBA.TS2.FCOPY1
                     Shrlevel : Reference
                     Type     : Local Primary            Dsnum  : 0
                     File Seq : 0                        DevType: 3390

Related topic

Overview-of-automated-drop-recovery

 

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