The Drop Recovery Log

The drop must have been initiated by one of the following BMC products:

• Catalog Manager
• ALTER
• Change Manager
• BMC AMI Command Center

For more information about dropping and recovering objects, see Dropping-and-recovering-objects.

To browse the Drop Recovery Log

1. On the Primary Menu panel or any list panel, on the Command line, type MAINTAIN ( MAINT ).

2. On the Log Maintenance Menu panel, select Browse Drop Recovery Log.The Browse Recovery Log panel is displayed.

   DEFF-R ---------------------  Browse Recovery Log  ---------------------------
   Command ===>
   Type browse specifications and press Enter.
   Column          Operator    Value
   -------------------------------------------------------------------------------
   Timestamp  . . . =                                   yyyy-mm-dd-hh.mm.ss.nnnnnn
   Authid . . . . . =
   Object_Type  . . =
   Object_Qual  . . =
   Object_Name  . . =
   Product  . . . . =
   You may add additional conditions in the WHERE clause below
   WHERE
3. On the Browse Recovery Log panel, in the Authid field, type and operator and a value for the authorization ID.
4. (optional) Specify a WHERE clause for the SQL statement.If you include a WHERE clause, observe the following rules:
   • Use the column names as they are displayed on the Browse Session Log panel.
   • Use correct SQL case, punctuation, and syntax as required by Db2.
   • Use only wildcards that are supported by Db2.

5. Press Enter.The Recovery Log List panel is displayed.

   DEFF-R ----------------------  Recovery Log List  ---------- Row 1 to 16 of 18
   Command ===>                                                  Scroll ===> CSR
                                                                                01
   CMD will show commands for this list.  Type command and press ENTER
   Enter L for Drop Recovery detail, DELETE to delete a specific entry.
   WHERE A.SEQUENCE = 1 AND A.DROP_SEQ = 1 AND A.AUT
   Cmd  Date     Time  AuthId   Product  Type   Name
   ----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
      2011-02-01 14.43 RDAPXB2  ACT010   TS     DBXNAUT.SBXNCOL
      2011-01-27 16.03 RDAPXB3  AEX010   DB     PLBNAUT
      2011-01-19 16.25 RDAPXB2  ACT010   TS     PLBDBA1.PLBALT02
      2011-01-19 14.09 RDAPXB2  ACT010   TS     PLBDBA1.PLBALTER
      2011-01-17 14.16 RDAPXB2  ACT010   TS     PXBQXPB.HASHPXB1
      2011-01-17 14.14 RDAPXB2  ACT010   TB     PXBTMPDB.HASH_BY_RANGE_NOT_
      2011-01-07 15.52 RDAPXB2  AEX010   TS     MXCDBG5.MXSS01G5
      2011-01-07 15.46 RDAPXB2  AEX010   TS     MXCDBG5.MXSS01G5
      2010-12-15 13.12 RDAPXB2  ACT010   TS     QCHD14.PXBS0214
      2010-11-05 15.52 RDAPXB   ACT010   DB     PXBQXPB
      2010-09-14 17.22 RDAPXB3  ACT010   TB     QCH_LONG.QCH_LONG_NAME_TABL
      2010-07-29 17.53 RDAPXB   ACT010   TB     ACTB.CORTAPST
      2010-04-20 11.20 RDAPXB   ACT010   TS     ACTIBPXB.ACTSPXB1
      2010-04-20 11.09 RDAPXB   ACT010   TS     ACTQX13.ACTS0113
      2010-04-20 11.07 RDAPXB   ACT010   TS     ACTQX13.ACTS0113
      2010-04-19 15.37 RDAPXB   ACT010   TS     ACTQV10.ACTSV010
6. In the Cmd column for the appropriate items, type L to view detailed information about entries on the list.

7. Press Enter.The Recovery Log Detail panel is displayed.

   DEFF-R ---------------------  Recovery Log Detail  ----------- Row 1 to 4 of 4
   Command ===>                                                  Scroll ===> CSR
                                                                                02
   Enter D or S to describe a single recovery log row.
   TABLESPACE=DBXNAUT.SBXNCOL
   Cmd Seq  Type Name                            Text
   ----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
           1 TS  DBXNAUT.SBXNCOL                  CREATE TABLESPACE SBXNCOL IN DB
           2 TB  RDABXN.TBXNCOL                   CREATE TABLE RDABXN.TBXNCOL ( C
           3 TB  RDABXN.TBXNCOL                   ALTER TABLE RDABXN.TBXNCOL ACTI
           4     RDABXN.MBXN_MASK                 CREATE MASK RDABXN.MBXN_MASK ON
   ******************************* Bottom of data ********************************
8. In the Cmd column for the appropriate items, type D or S to view detailed information about entries on the list.

9. Press Enter.The Describe Audit Log Entry panel is displayed, which shows information from the Drop Recovery Log.

   DEFF-R ------------------  Describe Audit Log Entry  ------- Row 1 to 18 of 23
   Command ===>                                                  Scroll ===> CSR
                                                                                03
   -------------------------------------------------------------------------------
   FROM ACT101.RECOVERY_LOG
   ------------------------------------------------------------------------------
    Logts. . . . . . : 2011-02-01-14.43.53.716869
    Authid . . . . . : RDAPXB2
    Session_seq. . . : 1
    Sequence . . . . : 1
    Drop_seq . . . . : 1
    DBID . . . . . . : 350
    OBID . . . . . . : 1
    PSID . . . . . . : 2
    Object_type. . . : TABLESPACE
    Object_qual. . . : DBXNAUT
    Object_name. . . : SBXNCOL
    Dep_obj_typ. . . : TABLESPACE
    Dep_obj_qal. . . : DBXNAUT
    Dep_obj_nam. . . : SBXNCOL
    Product. . . . . : ACT010
    Action . . . . . :  CREATE TABLESPACE SBXNCOL IN DBXNAUT USING STOGROUP
10. Press END to move to the next Describe Audit Log Entry panel (if you selected multiple items) or back to the Recovery Log Detail panel.