Failure to re-create dropped objects

Log Master can generate the DDL statements required to re-create dropped objects and their relationships, or you can provide these statements yourself (for example, by using saved copies of CREATE DDL statements).

To prevent errors, be sure to execute the generated (or provided) DDL statements to re-create the dropped objects at the correct point in the automated drop recovery.

  • If BMC AMI Log Master for Db2 generates the DDL statements, ensure that you specify Y in the Execute DDL field of the Generate Automated Drop Recovery panel (or specify the EXECUTE keyword in the RECREATE DATASET clause of the DROPRECOVERY statement).

  • If you provide the DDL statements, ensure that you execute them before you execute the automated drop recovery.

If you do not re-create the dropped objects either during or before the initial step in the automated drop recovery, Log Master issues message BMC097667, stating that ALL XLAT OBIDS WERE NOT RESOLVED. The message indicates that Log Master cannot obtain OBIDs for the new objects because the objects do not exist.


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

Comments