Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    45

    Unanswered: getting error in db2look utility

    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

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    try to rebind the db2look package..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Aug 2011
    Posts
    45
    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

  4. #4
    Join Date
    Aug 2011
    Posts
    45

    Thumbs up

    Issue has been resolved by binding db2lkfun.bnd

    Regards,
    Harsh Verma

Posting Permissions

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