IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Help on EXPLAIN -


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jpdeshai

New User


Joined: 24 Jun 2007
Posts: 57
Location: US

PostPosted: Fri Jun 26, 2009 1:41 am
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 26, 2009 2:50 am
Reply with quote

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
View user's profile Send private message
jpdeshai

New User


Joined: 24 Jun 2007
Posts: 57
Location: US

PostPosted: Fri Jun 26, 2009 3:17 am
Reply with quote

Thanks Dick. I will try that way.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Jun 26, 2009 4:43 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts Can someone explain me this JCL line ... JCL & VSAM 9
No new posts DB2 Explain DB2 3
No new posts can some one explain the below code... JCL & VSAM 3
No new posts Please explain this SQL CODE. DB2 4
Search our Forums:

Back to Top