Tools ‐ db2look - andyoolala/DB2 GitHub Wiki

Get Whole Database object's DDL

db2look -d ${DB_NAME}  -e -l -o file.out

Get Table's DDL

db2look -d ${DB_NAME} -z ${TABSCHEMA} -t ${TABNAME} -a -e -x -o file.out

db2look -d ${DB_NAME} -z ${TABSCHEMA} -t ${TABNAME} -e -x -noview -nofed

cat table_list | while read tschema ttable ;do db2look -d ${DB_NAME} -z ${tschema} -t ${ttable} -noview -nofed  -e -x ; done > tables.clp