Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009
    Posts
    14

    Unanswered: Why to split db2look file?

    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

  2. #2
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    there is a -ct option in db2look to generate DDL by object creation time. This should do.

    db2look - DB2 Statistics and DDL Extraction Tool
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •