| |
|
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.
|
 |
08-04-04, 15:58
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 253
|
|
|
Access Plan Graph
|
|
I'm running version 8, FixPak 3 on Windows. For some reason, now when I run a query in Command Center and have "Create Access Plan" chosen, Command Center isn't generating an access plan at all.
The thing is this was working just fine a couple of weeks ago. I can't think of anything I've done that would cause this to break.
If anyone has experienced something similar or has heard of something like this, any help would be appreciated.
Thanks!!
__________________
Anthony Robinson
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."
|
|
08-05-04, 09:30
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
Check to make sure that the option to automatically generate the Access Plan is turned on. From Command Center -> Options, goto the Access Plan tab and make sure that the option is checked.
Andy
|
|
08-05-04, 10:32
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 253
|
|
|
|
It is turned on...that's the problem...
__________________
Anthony Robinson
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."
|
|
08-05-04, 10:36
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
Does it do anything if you run the following simple query:
select tabschema,tabname from syscat.tables
Andy
|
|
08-05-04, 12:12
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 253
|
|
nada amigo....
Yesterday I was runnning very simple queries with the same result: select * from TABLE, etc.
Kinda weird.
Should also note that the EXPLAIN tables are there and I do have permissions on it (db2admin).
__________________
Anthony Robinson
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."
|
|
08-05-04, 12:28
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
What happens if you delete all the data in the explain tables?
Andy
|
|
08-05-04, 15:02
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 253
|
|
Seems that all the explain tables were completely empty
__________________
Anthony Robinson
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."
|
|
08-05-04, 15:10
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
What happens when you try executing the queries to get an access plan while logged in as the instance owner?
Andy
|
|
08-05-04, 17:27
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 253
|
|
Same thing...
Using db2admin who is the owner of the instance/schema, has dbadm, sysctrl, etc. privileges....
Noticed that nothing is getting written to the EXPLAIN tables...
__________________
Anthony Robinson
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."
|
|
08-05-04, 17:45
|
|
Registered User
|
|
Join Date: Aug 2004
Posts: 6
|
|
I've seen something similar when the Explain tables were generated at another version of UDB. We had to drop and just reran the explain as dbadm to have new tables created.
Hope that might help.
|
|
08-16-04, 11:53
|
|
Registered User
|
|
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 253
|
|
The version of DB2 is 8 - not using two different versions.
Droppd the tables that were already out there....
I'm able to generate Graphs and Explain statements with my other tools, just can't do it with Command Center?!? What gives ?
__________________
Anthony Robinson
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."
|
|
08-17-04, 08:28
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,575
|
|
I suggest you contact IBM on this issue.
Andy
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
Access Plan Graph
