I need to capture tablespace ddl and table ddl seperately from production database? does anyone know how to do it using db2look?

Thanks in advance
toby

Please post OS and Version

If you're on AIX/Unix/Linux
type: 'db2look' and you will
get an exhaustive listing of
options that will allow you to
specify your output.

BOW

db2look -d DBname -e -x -o outputfile


this will give all tables,index,views,alias,grants.


for only tablespaces


use this , to get DDl for BPs;Tablespaces

db2look -d DBname -l -o outputfilename


if you want only DB & DBM cfg

use this

db2look -d DBname -f -o outputfilename


Hope this will help you


Lekharaju Ennam
Certified Oracle8i & DB2 UDB DBA