A table has been dropped and only the DB2 Archive logs are available. Which CA DB2 tool can generate DDL for a dropped DB2 object such as a tablespace or table?

Document ID : KB000026303
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

A table has been dropped and only the DB2 Archive logs are available. Which CA DB2 tool can generate DDL for a dropped DB2 object such as a tablespace or table?

Environment:

DB2 Version 8 and above.

Answer:

Log Analyzer for DB2 for z/OS (PLA) can create DDL for a dropped object by reading the DB2 logs.  PLA DDL Generation:
The DDL Activity function can be used to help generate executable DDL statements to redo the creation of or undo the dropping of an Object.