getting sql0818n on db2advis

[Roger]

i am trying to run advise using the following parameter and i get this
error against one of the database :
db2advis -d db1 -i test.sql

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

exiting with error code [-818]



How can I fix it ?

TIA

Roger

[Colin Booth]

Re: getting sql0818n on db2advis

Roger wrote:

i am trying to run advise using the following parameter and i get this
error against one of the database :
db2advis -d db1 -i test.sql
>
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
>
exiting with error code [-818]
>
>
>
How can I fix it ?
>
TIA
>
Roger

You need to bind the packages used for the adviser. The messages says that
the bound package does not match that required by the application. (See
information center SQL messages) Look in the information center / release
notes etc. to see what you have to bind.


Colin

[Roger]

Re: getting sql0818n on db2advis

Hi colin,
I looked at those, it doesn't say what all packages I have to bind. I
bound all the db2ad*.bnd files from the sqllib/bnd directory and
still has no success.

Thanks