Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2004
    Posts
    38

    Unanswered: db2look dumps core

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you have a support contract, raise this as an issue with IBM
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    db2look

    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..
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    Jun 2004
    Posts
    38
    Raised a PMR with IBM, Expecting a build by next week to solve the problem. Thanks, Vij.

  5. #5
    Join Date
    Jun 2004
    Posts
    38
    Raised a PMR with IBM, Expecting a build by next week to solve the problem. Thanks, Vij.

Posting Permissions

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