471,896 Members | 2,571 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,896 software developers and data experts.

can db2advis be told a non default schema?

1
Hi folks:

My environment:

db2level: "DB2 v8.1.0.48", "s040212", "MI00069", FixPak "5".
db2licm -l: DB2 Enterprise Server Edition
uname -a: Linux 2.6.17-1.2187_FC5smp

My question:

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.

Thank you in advance.

(I apologize for crossposting)
May 10 '07 #1
0 1417

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Matthew Dauphinee | last post: by
reply views Thread by lelle | last post: by
2 posts views Thread by Roger | last post: by
reply views Thread by db2dbdba | last post: by
reply views Thread by suniltcs | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.