Hi All,
I am working on db2 8.2 on AIX platform.
I am facing issues with db2look command:
when I issued the command db2look -d dbname -t tabname -x -e -a
it is giving me the error :


unhod54:uding604 :/db2data/uding604/sqllib/bnd> db2look -d XXX -t Tabname -x -e -a
-- Generate statistics for all creators
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- This CLP file was created using DB2LOOK Version 8.2
-- Timestamp: Fri Nov 25 10:56:35 IST 2011
-- Database Name: UDING604
-- Database Manager Version: DB2/6000 Version 8.2.5
-- Database Codepage: 819
-- Database Collating Sequence is: UNIQUE


CONNECT TO UDING604;
SQL0818N A timestamp conflict occurred. SQLSTATE=51003

But this command is running fine with the option -a, if given alone.
Rest of the options are giving problems.
Can any on has faced the same issues or having some ideas over the same.


Regards,
Harsh Verma

try to rebind the db2look package..

Have already done that, but no result:


db2 bind db2look.bnd

LINE MESSAGES FOR db2look.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.


db2look -d xxxxx -t xxxL -x -e -a
-- Generate statistics for all creators
-- The db2look utility will consider only the specified tables
-- Creating DDL for table(s)
-- This CLP file was created using DB2LOOK Version 8.2
-- Timestamp: Fri Nov 25 12:54:46 IST 2011
-- Database Name: xxx
-- Database Manager Version: DB2/6000 Version 8.2.5
-- Database Codepage: 819
-- Database Collating Sequence is: UNIQUE


CONNECT TO xxxx;
SQL0818N A timestamp conflict occurred. SQLSTATE=51003

Issue has been resolved by binding db2lkfun.bnd

Regards,
Harsh Verma