Hello,

When I generate db2look script, I always need to bifurcate the main script in to different files manually (Ex: sapatate file for tblspace ddl, table ddl, func & proc ddl, sequences ddl etc.)! and then execute those files in sequence saparately.

If i don't do that way and directly execute main db2look file, it gives "Object not Found" error for dependent object whose parent's ddl comes later in the script.

IN SHORT: Why db2look script is not in appropriate sequence? and is there any way to generate it with exact sequence of objects.

Thanks!

P.S.: db2 v9.1 on solaris 5.10

there is a -ct option in db2look to generate DDL by object creation time. This should do.

db2look - DB2 Statistics and DDL Extraction Tool