View previous topic :: View next topic
|
Author |
Message |
jpdeshai
New User
Joined: 24 Jun 2007 Posts: 57 Location: US
|
|
|
|
Hi,
I am trying to run EXPLAIN on a SQL query first time through FILE AID DB2 (V6.0.0.19).
When i try to select a Query it is giving below error message.
Code: |
DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE
TSSXXXXX.PLAN_TABLE DOES NOT EXIST |
here, it is picking up my TSSID instead of Creator name.How do I change the TSS ID here?
Please help. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you can't. (well, maybe you can, but I would not suggest it.)
when you are in spufi or fileaid, you need to have created your own explain table. every application programmers guide has a chapter on explain (i think it is chap 6 in most versions). it has the sql to create your explain table for your version. as of 7 or 8, the table was expanded; you can also get resource consumption estimates. |
|
Back to top |
|
|
jpdeshai
New User
Joined: 24 Jun 2007 Posts: 57 Location: US
|
|
|
|
Thanks Dick. I will try that way. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
glad to help.
reason that you should use your own plan table is that often, the one that
is part of your compile/link/bind jcl is actually owned by the dba's and the
explain has access to the plan table because the job was submitted by the
resource manager (e.g. endevor).
That is why you can not access the 'creators' plan table (in spufi/fileaid)
and you need your own. |
|
Back to top |
|
|
|