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

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

A table has been dropped and only the Db2 Archive logs are available. Which Database Management Solutions for Db2 for z/OS tool
can generate DDL for a dropped Db2 object such as a tablespace or table?

Resolution

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.