469,275 Members | 1,802 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

db2advis from Client

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

Nov 17 '05 #1
1 3951
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

Nov 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by norab | last post: by
1 post views Thread by mandible | last post: by
2 posts views Thread by hello_db2 | last post: by
reply views Thread by db2dbdba | last post: by
reply views Thread by suniltcs | last post: by
3 posts views Thread by sandeep.iitk | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.