When I use db2look -d mydb -a -e -l -f -xd -o db2look.sql it fails by dumping a core file.

My db2level is as below
> db2level
DB21085I Instance "card30" uses "32" bits and DB2 code release "SQL08020" with
level identifier "03010106".
Informational tokens are "DB2 v8.1.1.64", "s040812", "U498350", and FixPak "7".
Product is installed at "/usr/opt/db2_08_01".

However if I remove the -xd option db2look works fine. Is it a pbm listed in http://www-1.ibm.com/support/docview...id=swg1IY53080

Do I need to upgrade my db2 to a different fixpack level ? I tried the same in the same database but in FP 10 but there too I got a pbm. I have lot of COMMENT statement in my database.

Any Clue?

Thanks, Vij.

If you have a support contract, raise this as an issue with IBM

there is a known problem with db2look (we raised..) for some table functions
this is corrected in fp10
http://www-1.ibm.com/support/docview...=utf-8&lang=en
have a look.. and yes, you need to upgrade..

Raised a PMR with IBM, Expecting a build by next week to solve the problem. Thanks, Vij.

Raised a PMR with IBM, Expecting a build by next week to solve the problem. Thanks, Vij.