If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: can db2advis be told a non default schema?

I am trying to run db2advis o a third party DB (restored by db2move). The schema for this db does not match any user on my system, and i am facing this puzzle: no user is able to find explain and advise tables, even though i created them with EXPLAIN.DLL. db2advis routinely prompts me with a SQLSTATE "42704" msg.

Things what i have already done:

-setting schema in the shell (tcsh): no way
-setting schema in the file containing the queries i want to be advised about: no way
-setting the schema in the db2cli.ini file: no way
-creating the advise and explain tables under the SYSTOOLS schema (as told in http://publib.boulder.ibm.com/infoce...dex.jsp?topic= ): no way

What else can i try? Can db2advis to be told to search for tables under a non default schema? I could create a dummy user matching the schema name of the target DB, but i prefer a principled solution.