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.