Results 1 to 5 of 5
  1. #1
    Join Date
    May 2009
    Posts
    8

    Question Unanswered: db2look comand in db2 9.5

    Hi All

    I hope that some one can help me again using db2look comand in db2 9.5 I used to this command on db2 v8 and ran fine:

    db2look -ct -d dkdev -i ico -w gone4day -u ico -z ico -e -x > test2.ddl
    But using db2 v 9.5 I get this:

    $ more test2.ddl
    -- This CLP file was created using DB2LOOK Version "9.5"
    -- Timestamp: Fri 19 Jun 2009 10:28:54 AM EDT
    -- Database Name: DKDEV
    -- Database Manager Version: DB2/LINUXX8664 Version 9.5.3
    -- Database Codepage: 1208
    -- Database Collating Sequence is: IDENTITY


    CONNECT TO DKDEV USER icof;

    Call DB2LK_GENERATE_DDL failed, sqlcode is -443;

    SYSPROC.DB2LK_GENERATE_DDL˙DB2LK_GENERATE_DDL˙Inva lid input SQLERFRP;

    I do not understand why I am getting this error, any help will be appreciated !

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    have you tried removing -ct?

    -ct Generate DDL by object creation time. Generating DDL by object creation time will not guarantee that all the object DDLs will be displayed in correct dependency order. The db2look command only supports the following options if the -ct option is also specified: -e, -a, -u, -z, -t, -tw, -v, -l, -noview.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    May 2009
    Posts
    8
    That means that the command must be:

    db2look -c -t -d dkdev -i ico -w gone4day -u ico -z ico -e -x > test2.ddl

    or

    In db2 9.5 this option -ct is no more support?

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    It means that if you use -ct you can not use -i or -u or -x that you have.

    Try

    db2look -d dkdev -i ico -w gone4day -u ico -z ico -e -x > test2.ddl
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    oh, and you might want to hide your pwd in the future
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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