Do db2 logs include DDL statements ?

vilius · #1 (**permalink**) 02-04-09, 07:04

Hi,

Do db2 logs include DDL statements ?
For example like "create table", "drop table" and etc.

thanks
Vilius

sathyaram_s · #2 (**permalink**) 02-04-09, 07:10

Yes, the create and drop objects are logged..

But not sure whether the ascii "create table " text is stored in DDL format

stolze · #3 (**permalink**) 02-04-09, 12:45

No, it is not - there is no reason to do so. The changes to the catalog tables are logged, and from the catalog you could reconstruct the CREATE TABLE statement (and "db2look" does exactly that). The only thing you loose are information where defaults were used.