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 - 17 Nov 2005 13:40 GMT
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