Hi,

I am trying to run DB2ADVIS but I have this error:
Database is reporting the following error:

error. The db2advis tool needs the explain tables and
the advise tables to exist. Please create them
using the EXPLAIN.DDL script in the misc subdirectory
of the sqllib directory.

But I have created all the table from EXPLAIN.DDL.
Can someone help me?

Thanks.
The version is 8.2(upgrade from 8.1), OS is solaris

Maybe the schema is different? Or the privilege of current user?

No, the schema is same, the user is instance user!

Hi,
if you created explain tables before migration to 8.2 you need to drop explain tables and recreate them again. There was some changes in explain tables during version 8.1.
Hope this helps,
Grofaty