Failure to create a temporary table space
When you recover a dropped table,
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.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*