Default language.

Failure to create a temporary table space


When you recover a dropped table, BMC AMI Log Master can generate the DDL statements that are required to create a temporary table space that holds a temporary copy of the table, or you can provide these statements yourself.

If you provide the DDL statements, ensure that you execute them and create the temporary table space before executing the automated drop recovery.

If the temporary table space for the copy of the dropped table does not exist, the product issues message BMC097667, stating TEMPORARY TABLESPACE FOR DROPPED TABLE NOT IN DB2 CATALOG.

 

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

BMC AMI Log Master for Db2 13.1