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.
).
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.