The Drop Recovery Log
The Drop Recovery Log records all of the DDL necessary for
Catalog Manager
to recover a dropped object structure, its dependents, and its data.
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
- On the Primary Menu panel or any list panel, on the Command line, type MAINTAIN ( MAINT ).
On the Log Maintenance Menu panel, select Browse Drop Recovery Log.The Browse Recovery Log panel is displayed.
DEMO-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
- On the Browse Recovery Log panel, in the Authid field, type an operator and a value for the authorization ID.
- (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 Recovery Log panel.
- Use correct SQL case, punctuation, and syntax as required by Db2.
- Use only wildcards that are supported by Db2.
Press Enter.The Recovery Log List panel is displayed.
DEMO-R ---------------------- Recovery Log List ---------- Row 1 to 35 of 37
Command ===> Scroll ===> PAGE
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 FOR FETC
Cmd Date Time AuthId Product Type Name
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
2022-02-28 15.19 MVSIXE1 GUD131 PR ALTLONG.ALT31BT1
2022-02-28 15.19 MVSIXE1 GUD131 PR ALTLONG.ALT30BT1
2022-02-28 12.26 MVSIXE1 GUD131 PR ALTLONG.ALT129BT
2022-02-28 11.59 MVSIXE1 GUD131 PR ALT_LONG.ALT_NP1_QM00170945
2022-02-28 11.50 MVSIXE1 GUD131 PR ALT_LONG.ALT_NP1_QM00170945
2022-02-28 11.50 MVSIXE1 GUD131 PR ALT_LONG.ALT_NP1_QM00170945
2022-02-28 11.50 MVSIXE1 GUD131 PR ALT_LONG.ALT_NP1_QM00170945
2022-02-28 11.50 MVSIXE1 GUD131 PR ALT_LONG.ALT_NP1_QM00170945
2022-02-28 11.50 MVSIXE1 GUD131 PR ALT_LONG.ALT_NP1_QM00170945
2022-02-28 10.55 MVSIXE1 GUD131 PR ALTLONG.ALT128BT
2022-02-28 10.55 MVSIXE1 GUD131 TB ALTDB000.ALTT03
2022-02-17 12.36 MVSIXE1 GUD131 DT QCH.QCHDTDF
2022-02-16 10.42 MVSIXE1 GUD131 PR ALTLONG.ALT30BT1
2022-02-16 10.40 MVSIXE1 GUD131 PR ALTLONG.ALT31BT
2022-02-16 10.31 MVSIXE1 GUD131 PR ALTLONG.ALT128BT_02
2022-02-10 18.00 MVSIXE1 GUD131 DB ALTDE29
2022-02-10 18.00 MVSIXE1 GUD131 DB ALTDE26
2022-02-10 18.00 MVSIXE1 GUD131 DB ALTDE25
2022-02-10 18.00 MVSIXE1 GUD131 DB ALTDE24
2022-02-10 18.00 MVSIXE1 GUD131 DB ALTDE23
2022-02-10 17.49 MVSIXE1 GUD131 DB ALTDE18
2022-02-10 17.49 MVSIXE1 GUD131 DB ALTDE17
2022-02-10 17.49 MVSIXE1 GUD131 DB ALTDE16
2022-02-10 17.49 MVSIXE1 GUD131 DB ALTDE15
2022-02-10 17.49 MVSIXE1 GUD131 DB ALTDE14
2022-02-10 17.47 MVSIXE1 GUD131 DB ALTDE13
2022-02-10 17.37 MVSIXE1 GUD131 IX ALT_SCHE.ALTX00_DE01S06T06_
2022-02-03 11.46 MVSIXE1 GUD131 PR ALTLONG.ALT31BT
2022-02-03 11.45 MVSIXE1 GUD131 PR ALTLONG.ALTNP01
2022-02-03 11.45 MVSIXE1 GUD131 PR ALTLONG.ALTNP02
2022-02-03 11.45 MVSIXE1 GUD131 PR ALTLONG.ALTNP03
2022-02-03 11.45 MVSIXE1 GUD131 PR ALTLONG.ALTNP04
2022-02-03 10.07 MVSIXE1 GUD131 PR ALTLONG.ALTNP04
2022-02-03 10.07 MVSIXE1 GUD131 PR ALTLONG.ALTNP05
2022-02-03 10.06 MVSIXE1 GUD131 PR ALTLONG.ALTNP03- In the Cmd column for the appropriate items, type L to view detailed information about entries on the list.
Press Enter.The Recovery Log Detail panel is displayed.
DEMO-R --------------------- Recovery Log Detail -------- Row 1 to 35 of 116
Command ===> Scroll ===> PAGE
02
Enter D or S to describe a single recovery log row.
DATABASE=ALTDE26
Cmd Seq Type Name Text
----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---
1 DB ALTDE26 CREATE DATABASE ALTDE26 BUFFERP
2 DB G GRANT DBADM ON DATABASE ALTDE26
3 DB GRANT DBCTRL, DBMAINT, CREATETA
4 DB GRANT DBMAINT, CREATETAB, CREAT
5 DB GRANT CREATETAB, CREATETS, DISP
6 DB G GRANT DBADM ON DATABASE ALTDE26
7 DB GRANT DBCTRL, DBMAINT, CREATETA
8 DB GRANT DBMAINT, CREATETAB, CREAT
9 DB GRANT CREATETAB, CREATETS, DISP
10 DB G GRANT DBADM ON DATABASE ALTDE26
11 DB GRANT DBCTRL, DBMAINT, CREATETA
12 DB GRANT DBMAINT, CREATETAB, CREAT
13 DB GRANT CREATETAB, CREATETS, DISP
14 TS ALTDE26.ALTS0212 CREATE TABLESPACE ALTS0212 IN A
15 TB ALT_SCHE.ALTT01_DE26S02_128 -- SET CURRENT SQLID = 'MVSIXE1'
16 TB ALT_SCHE.ALTT01_DE26S02_128 CREATE TABLE ALT_SCHEMA_128BYTE
17 TB ALT_SCHE.ALTT01_DE26S02_128 -- SET CURRENT SQLID = USER
18 IX ALT_SCHE.ALTX01_DE26S02T01_ CREATE INDEX ALT_SCHEMA_128BYTE
19 VW ALT_SCHE.ALTV01_DE26S02T01_ -- SET CURRENT SQLID = 'MVSIXE1'
20 VW ALT_SCHE.ALTV01_DE26S02T01_ SET CURRENT PATH = "ALT_SCHEMA_
21 VW ALT_SCHE.ALTV01_DE26S02T01_ CREATE VIEW ALT_SCHEMA_128BYTES
22 VW ALT_SCHE.ALTV01_DE26S02T01_ -- SET CURRENT SQLID = USER
23 VW ALT_SCHE.ALTV01_DE26S02T01_ SET CURRENT PATH = SYSTEM PATH
24 TS ALTDE26.ALTS0312 CREATE TABLESPACE ALTS0312 IN A
25 TB ALT_SCHE.ALTT02_DE26S02_128 -- SET CURRENT SQLID = 'MVSIXE1'
26 TB ALT_SCHE.ALTT02_DE26S02_128 CREATE TABLE ALT_SCHEMA_128BYTE
27 TB ALT_SCHE.ALTT02_DE26S02_128 -- SET CURRENT SQLID = USER
28 IX ALT_SCHE.ALTX01_DE26S02T02_ CREATE INDEX ALT_SCHEMA_128BYTE
29 IX ALT_SCHE.ALTX02_DE26S02T02_ CREATE INDEX ALT_SCHEMA_128BYTE
30 IX ALT_SCHE.ALTX03_DE26S02T02_ CREATE INDEX ALT_SCHEMA_128BYTE
31 IX ALT_SCHE.ALTX04_DE26S02T02_ CREATE INDEX ALT_SCHEMA_128BYTE
32 VW ALT_SCHE.ALTV01_DE26S02T02_ -- SET CURRENT SQLID = 'MVSIXE1'
33 VW ALT_SCHE.ALTV01_DE26S02T02_ SET CURRENT PATH = "ALT_SCHEMA_
34 VW ALT_SCHE.ALTV01_DE26S02T02_ CREATE VIEW ALT_SCHEMA_128BYTES
35 VW ALT_SCHE.ALTV01_DE26S02T02_ -- SET CURRENT SQLID = USER- In the Cmd column for the appropriate items, type D or S to view detailed information about entries on the list.
Press Enter.The Describe Recovery Log Entry panel is displayed, which shows information from the Drop Recovery Log.
DEMO-R ----------------- Describe Recovery Log Entry ----- Row 1 to 27 of 27
Command ===> Scroll ===> PAGE
03
-------------------------------------------------------------------------------
FROM ACT131.RECOVERY_LOG
------------------------------------------------------------------------------
Logts. . . . . . : 2022-02-10-18.00.36.416189
Authid . . . . . : MVSIXE1
Session_seq. . . : 4
Sequence . . . . : 1
Drop_seq . . . . : 14
DBID . . . . . . : 688
OBID . . . . . . : 1
PSID . . . . . . : 2
Object_type. . . : DATABASE
Object_qual. . . :
Object_name. . . : ALTDE26
Dep_obj_typ. . . : TABLESPACE
Dep_obj_qal. . . : ALTDE26
Dep_obj_nam. . . : ALTS0212
Product. . . . . : GUD131
Action . . . . . : CREATE TABLESPACE ALTS0212 IN ALTDE26 USING STOGROUP
ALTSG12_STOGROUP_128BYTES_LONG_NAME_XXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXALT PRIQTY 400 SECQTY 200 ERASE NO FREEPAGE 0
PCTFREE 0 FOR UPDATE -1 GBPCACHE CHANGED COMPRESS NO
TRACKMOD YES NOT LOGGED DSSIZE 1 G SEGSIZE 16
MAXPARTITIONS 1 BUFFERPOOL BP0 LOCKSIZE ANY LOCKMAX
SYSTEM CLOSE NO CCSID EBCDIC MAXROWS 255 INSERT ALGORITHM
0
------------------------------------------------------------------------------
******************************* Bottom of data ********************************- Press END to move to the next Describe Recovery Log Entry panel (if you selected multiple items) or back to the Recovery Log Detail panel.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*