Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
So it looks like the problem was that when I was using v6, I was changing the "Schema" drop-down in my Query Analyzer.
When I would select "Execute Explain", I would get to results -- this looks like it was because ADS would look in the schema that was selected in the drop-down for the explain tables, but db2 put the explain data in the schema for the user who had logged in.
When I changed my query to explicitly use the tables in the schema I wanted, and selected the schema that matched the user I had logged in as from the drop-down, everything worked as expected.
|
|
52 KB
Tested with ADS build 7.4.18 and didnt find anything wrong with Visual Explain. Changed the schemas in the query analyser and executed queries. The explain plan displayed plan of schemas other than the one logged in without any problem. The other thing noted was the NULL values for the completed queries as displayed in pic
1.) Logged as db2admin
2.) Changed Drop down Schema to db2nci
3.) Deleted Explain Tables of all 3 schemas
Execute query with drop down = db2nci and table referring to DBO
select * from DBO.CUSTOMERINFOEXTRA
Since all Explain tables of dropdown, referring schema and logges in user is deleted -- gave me the Error Message
Describe Error: Failed to execute EXPLAIN plan: The required Explain table "DB2ADMIN.EXPLAIN_INSTANCE" does not exist.. SQLCODE=-219, SQLSTATE=42704, DRIVER=3.53.71
Describe Error: Failed to disable execution plan: "DB2ADMIN.EXPLAIN_OPERATOR" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.53.71
1.) Logged as db2admin
2.) Changed Drop down Schema to db2nci
3.) Deleted Explain Tables of all 3 schemas
Execute query with drop down = db2nci and table referring to DBO
select * from DBO.CUSTOMERINFOEXTRA
Since all Explain tables of dropdown, referring schema and logges in user is deleted -- gave me the Error Message
Describe Error: Failed to execute EXPLAIN plan: The required Explain table "DB2ADMIN.EXPLAIN_INSTANCE" does not exist.. SQLCODE=-219, SQLSTATE=42704, DRIVER=3.53.71
Describe Error: Failed to disable execution plan: "DB2ADMIN.EXPLAIN_OPERATOR" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.53.71
Issue #849 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Tested with ADS build 7.4.18 and didnt find anything wrong with Visual Explain. Changed the schemas in the query analyser and executed queries. The explain plan displayed plan of schemas other than the one logged in without any problem. The other thing noted was the NULL values for the completed queries as displayed in pic