Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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: 2013-01-18            LOG MASTER FOR DB2 -  V11.01.00        Page:       1
 Time: 10.04.20         Copyright BMC Software, Inc. 1995-2013

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

Was this page helpful? Yes No Submitting... Thank you

Comments