udb db2 on 13 07 db2look

1)To Get The Data base LayoutàDatabase Partion groups ,Bufferpools and Tablespaces

<MAHESH>db2look -d testdbs –l

2)To Generate the DDL Statements for objects created by the useràBy this command we can also know primary , other key informations

Commandà

                                          <MAHESH>db2look -d testdbs -i mahesh  -e

3)Generate the DDL Statements for objects created by ALL USERS in the database .

àTo Send the output to a file use option -0 file name

Command à

<MAHESH>db2look -d sample -a –e