Specifying Db2 objects to recover
Before you begin
Ensure that you understand the concepts presented in Identifying-objects-to-recover.
To specify Db2 objects to recover
In the BMC AMI Log Master for Db2 Main Menu, select 8. Generate Automated Drop Recovery and press ENTER.BMC AMI Log Master displays the Generated Automated Drop Recovery panel. For information about the fields on this panel, press F1 to access the online Help.
Generate Automated Drop Recovery
Command ===>
DB2 : DB2A
Work ID . . : USER2.$$WORKID0003
Description : USER2 2022-01-19 09.10.26 DROP RECOVERY
------------------------------------------------------------------------------
Specify Dropped Object(s)
Object Type . . . TB (DB=Database, TS=Table Space, TB=Table)
Object Name . . . DB2DBA.YEAR_END_FINANCIAL_S>>
Additional Objects . . . . . _ (E=Enter additional object names)
Specify when DROP occurred
Start of Range - Date . . . . 2022-01-18 Time . . . 09.10.27.000000
End of Range - Date . . . . 2022-01-18 Time . . . 09.10.27.000000
Specify Other Range . . . . . _ (E=Edit)
Specify Outputs Desired
Drop Recovery Report . . . . _ (E=Edit, D=Delete)
DSN: USER2.DROPREC.REPORT
Report Template. . . . . . _ (E=Edit, D=Delete)
Recreate DDL . . . . . . . . _ (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.RECREATE.&SYSUID..DDL(MEMBER)
Execute DDL . . . . . . . Y (Y=Yes, N=No)
Bind Owner . . . . _________ (AUTHID)
SET SQLID . . . . _________ (Generate SET SQLID)
SET SCHEMA . . . . ________________ (Generate SET SCHEMA)
TRANSFER OWNERSHIP . . . . N (Y=Yes, N=No)
New Owner Type . . . . . _ (U=USER, R=ROLE)
New Owner . . . . ___________________(New Owner/Role Name)
BMC RECOVER . . . . _ (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.RECOVER.CNTL
Execute Recover . . . . . Y (Y=Yes, N=No)
Use LOGONLY option . . . . N (Y=Yes (for Non-DB2 restore only), N=No)
OUTCOPY specification . . A (A=ASCODED, B=BYPART)
Outcopy Outputs . . . . . _ (E=Edit outcopy output dataset options)
DSN1COPY. . . . . . . . . . . (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.DSN1COPY.CNTL
Execute Copy . . . . . . . N (Y=Yes, N=No)
Post Recover SQL . . . . . . _ (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.MIGRATE.SQL
Execute SQL . . . . . . . Y (Y=Yes, N=No)
Post Recover Rebinds . . . . _ (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.REBIND.CMDS
Execute Rebinds . . . . . Y (Y=Yes, N=No)
Post Recover Checks . . . . _ (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.CHECK.CMDS
Execute Checks . . . . . Y (Y=Yes, N=No)
Post Recover Runstats . . . . (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.RUNSTATS.CMDS
Execute Runstats . . . . . Y (Y=Yes, N=No)
Post Recover Repairs . . . . (E=Edit data set name, D=Delete)
DSN: USER2.DROPREC.REPAIR.CMDS
Execute Repairs . . . . . Y (Y=Yes, N=No)
Specify Recovery Type
Recovery Type . . . . . . . . R (R=BMC RECOVER, D=DSN1COPY)
Specify Additional Options . . .
Non-DB2 Restore . . . . . . . ________ (User defined JCL skeleton)
Press PF3 to save the workid or to generate JCL.- In the Object Type field, specify whether you want to recover a database, table space, or table.
- In the Object Name field, type a valid Db2 name for the object type that you specified in Step 2.
- (optional) If you have specified TS or TB in the Object Type field, and specified only one object name, you can define additional recovery options:
- Press Enter to refresh the panel and display the Options field (shown in the above figure in step 1).
- In the Options field, type E and press Enter.BMC AMI Log Master displays a panel where you can define additional recovery options. The available options depend on whether you are recovering a table space or a table.
(optional) To recover more than one dropped object, type E in the Additional Objects field and press Enter.BMC AMI Log Master displays the Dropped Object Names Maintenance panel (see the following figure), which you can use to create and maintain a list of Db2 objects to be recovered. For information about the fields on this panel, press F1 to access the online Help.
Dropped Object Names Maintenance Line 1 of 4
Command ===> Scroll ===> HALF
Maintain the list. Press F3 when done.
Enter an action code. Then press Enter.
I=Insert D=Delete R=Repeat O=Options
ACT TYPE OBJECT
_ DB DB2A
_ TS DB2A.TS4
_ TB MYTABLE.LIST1
_ TB EMPLOYE.ACCT34_______________________________________
************************* End Of List ***************************
F1=Help F3=Exit F4=Zoom F7=Forward F8=Backward F12=Cancel- Complete the step appropriate to your situation:
- If you do not want to generate output image copies during recovery, or if you do not have BMC AMI Recover installed, skip to Step 8.
(optional) If a dropped object is a table space and you want BMC AMI Recover to generate output image copies, type O beside the table space that will be recovered.
BMC AMI Log Master displays the BMC AMI Recover Outcopy Specification panel. The values that you specify on this panel describe the image copies that BMC AMI Recover creates when the generated JCL is run. For information about the fields on this panel, press F1 to access the online Help.
BMC RECOVER Outcopy Specification
Tablespace name . . : DB2DBA.ACCTNGTS04 More: +
TABLE SPACE INFORMATION
Partitions in the table space . . . 0 (0=nonpartitioned,
1-4096=partitioned)
OUTCOPY specification . . . . . . . . A (A=Ascoded, B=Bypart)
Clone . . . . . . . . . . . . . . . . N (Y=Yes, N=No)
OUTCOPYDDN specification
DDNAME1 . . . . BMCCPY (DDNAME or DDNAME prefix)
Register . . . Y (Y=Yes, N=No)
Primary . . . . (E=Edit data set name, D=Delete)
DSN:
DDNAME2 . . . . BMCCPZ (DDNAME or DDNAME prefix)
Register . . . Y (Y=Yes, N=No)
Secondary . . . (E=Edit data set name, D=Delete)
DSN:
RECOVERYDDN specification
DDNAME1 . . . . BMCRCY (DDNAME or DDNAME prefix)
Register . . . Y (Y=Yes, N=No)
Primary . . . . (E=Edit data set name, D=Delete)
DSN:
DDNAME2 . . . . BMCRCZ (DDNAME or DDNAME prefix)
Register . . . Y (Y=Yes, N=No)
Secondary . . . (E=Edit data set name, D=Delete)
DSN:
(optional) Specify the information that BMC AMI Recover requires to generate output image copies and press F3.BMC AMI Log Master saves your specifications and displays the Dropped Objects Names Maintenance panel.
If a dropped table space has a clone table and you want BMC AMI Recover to generate output image copies, type Y in the Clone field so that BMC AMI Log Master directs BMC AMI Recover to generate output images copies for clones.
- Complete the step most appropriate to your situation:
- If the dropped object is not a table, or if you do not want to change the default values, skip to Step 10.
(optional) To change the default values for the recovery of a dropped table, type O in the ACT column beside the table name and press Enter.
BMC AMI Log Master displays the Dropped Table Temporary Object Definition panel. For information about the fields on this panel, press F1 to access the online Help.
Dropped Table Temporary Object Definition
Use temporary objects (INDEP) . Y (Y=Yes, N=No)
If INDEP is set to Y, then enter the values for
temporary objects that will be used during the
recovery of the dropped table.
Storage Group . . . . . . . . . SYSDEFLT
Database . . . . . . . . . . . ALPTMPDB
Table Space . . . . . . . . . . ALPTMPTS
Owner . . . . . . . . . . . . . ALPTMPUS
If INDEP is set to N, then enter the location
of the dropped table to be recovered.
Database . . . . . . . . . . .
Table Space . . . . . . . . . .
F1=Help F3=Exit F4=Zoom F12=Cancel
- Specify the information that BMC AMI Recover requires to create temporary objects and press F3.BMC AMI Log Master saves your specifications and displays the Dropped Object Names Maintenance panel.
- Finish specifying any additional objects for recovery, and then press F3 to return to the Generate Automated Drop Recovery panel to specify a time frame during which the objects were dropped.