DB2advis error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • suniltcs
    New Member
    • Oct 2008
    • 2

    DB2advis error

    When I run DB2advis , i get below error message.
    ).


    db2advis -d aqwrwist -l -1 -s "select * from wis.cond with ur;"

    Using user id as default schema name. Use -n option to specify schema

    SQL0818N A timestamp conflict occurred. SQLSTATE=51003

    *************** *************** *******
    * CONTENTS OF SQLCA *
    *************** *************** *******

    SQLCABC = 136
    SQLCODE = -818
    SQLERRMC =
    SQLERRP = SQLRALDP
    sqlerrd[0] = 2148663405
    sqlerrd[1] = 0
    sqlerrd[2] = 0
    sqlerrd[3] = 0
    sqlerrd[4] = 0
    sqlerrd[5] = 0
    SQLWARN =
    SQLSTATE = 51003
    Critical SQLCODE. Exiting db2advis ...

    0 solutions were evaluated by the advisor




    =============== =============== =========

    I tried binding the package using below commands
    db2 terminate
    db2 CONNECT TO <dbname>
    db2 bind /usr/opt/db2_08_01/bnd/@db2ubind.lst BLOCKING ALL GRANT
    PUBLIC
    db2 bind /usr/opt/db2_08_01/bnd/@db2cli.lst BLOCKING ALL GRANT
    PUBLIC
    db2 bind /usr/opt/db2_08_01/bnd/db2schema.bnd blocking all grant public sqlerror continue
    db2 terminate

    but doesnt work.
    Please suggest something.
Working...