Hi all,

I am using db2look to extract DDL for all the tables along with authorization DDL. The problem I am facing is that db2look is generating "CREATE TABLE" DDL for almost all the tables I have but not all. Although I am getting authorization DDL for tables whose "CREATE TABLE" DDLs were not generated.

I used the following statement:-

db2look -d BOSS -u bossadmin -e -f -o ddl.sql

I am not sure why this is happening. I have more than 700 tables.

Can any one explain what is causing the problem and how I can get all the DDLs.

Thanks a lot,
Dev

You are specifying the table creator ID. Is there a chance that some tables have other creator than 'BOSSADMIN'?