469,267 Members | 1,091 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

How do you specify a default schema for DB2ADVIS?


I'm attempting to get DB2ADVIS to analyze some SQL that I have to
determine if any MDC tables would be appropriate (well, at least to
know what DB2 thinks). Unfortunately, I'm running into issues.

My SQL is using unqualified tables (generated from a tool), and I'd
like to be able to specify a specific schema that it should look for
these tables in.

Looking at the documentation, I would assume that -qualifier (or -q)
followed by a schema would cause DB2ADVIS to use the schema specified.
Unfortunately, it doesn't seem to be doing this. It proceeds to
determine that all the SQL is invalid, and gives a somewhat cryptic
Using user id as default schema name. Use -n option to specify schema

Then, down near the bottom of the output (after showing all the
options), it errors out with error code -106

Incidentally, if I provide a -n option, it no longer gives me the
message, but still doesn't find any valid SQL.

I have independantly run these SQL, and they do work, so I don't think
it is that. Also, if I include SQL in the statement where all tables
are owned by the specified user, then those are deemed valid SQL, and
it gives me suggestions about those.

Any ideas?


(ps - I'm on V9.10, LUW, Solaris)

Dec 12 '06 #1
0 1299

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by norab | last post: by
1 post views Thread by norab | last post: by
1 post views Thread by Erik Hendrix | last post: by
1 post views Thread by mandible | 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 suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.