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 !

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.

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?

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

oh, and you might want to hide your pwd in the future