db2advis from Client

[Anurag]

Hi All,
Server = DB2 ESE 8.2 on Linux, Client = DB2 Admin Client 8.2 on Windows

Question = Can I execute "db2advis" from this Windows Client?
Kindly see the error I receive and the setup below.

Setup = As below:
(1) EXPLAIN / ADVISE tables on database SRV are created in instance
owner schema "db2inst1".
(2) From windows I am connected to db SRV as user "db2inst1".
(3) On the Windows desktop, I am logged on as admin user "1255368"
(4) I execute these 2 commands (as an example):
db2 set current schema db2inst1;
db2advis -d SRV -s "SELECT CUST_ID FROM anurag.CUSTOMER "
-a db2inst1/db2inst1 -n db2inst1 -q anurag.

After a while, I receive the error as below:
_______________ __________ ERROR TEXT _______________ __________
Explain tables not set up properly for schema 1255368
The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-219]
_______________ _______________ _______________ _______________ ___

So, my question refined after this error is ==> When EXPLAIN / ADVISE
tables have been setup for the user with which I am connected to the
database (instance owner), why does my db2advis statement fails;
AND WHY IN THIS WORLD IS DB2 CONCERNED WITH MY WINDOWS USER ID 1255368
(VALUES CURRENT USER ===> db2inst1)?

Do I need to set some parameter for "CURRENT USER" at the Windows level
also?

Regards,
Anurag

[juliane26]

Hi,
why don't you give the userid and passwd as well?
db2advis is using it's own connection, not from the session, so hand it
over as well.
-a userid/passwd or
-a userid -x
will prompt for the password.

Juliane