Identifying objects to recover

To define an automated drop recovery work ID, you must specify the Db2 objects that were dropped from the Db2 catalog, including the following information:

Related topic

Overview-of-automated-drop-recovery

  • Type of objects to recover (table, table space, or database)

    BMC AMI Log Master provides automated drop recovery for LOB and XML table or table space objects. When you specify a LOB or XML base table or table space to be recovered, BMC AMI Log Master extends drop recovery discovery to include all of the associated LOB and XML auxiliary table spaces and tables.

  • Name of each object that was dropped from the Db2 catalog

  • Time frame when the objects were dropped from the Db2 catalog

    You can specify the start point or end point of a time frame in the following formats:

    • Date and time (the default format)
    • Log mark name
    • Log address value, either a relative byte address (RBA), or a log record sequence number (LRSN)
  • (optional) Location to place temporary objects that can be created during recovery, which are used to recover an individual table
  • (optional) Image copy definitions, which are used to create output image copies during the recovery

For each object, the Db2 log contains a DROP statement. When you run the automated drop recovery work ID, BMC AMI Log Master scans the log to determine information about the dropped Db2 objects.

 

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