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?
DB2 Version 8 and above.
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.