Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Help on EXPLAIN -

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Help on EXPLAIN -
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: 6970
Location: porcelain throne

PostPosted: Fri Jun 26, 2009 2:50 am    Post subject:
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    Post subject:
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: 6970
Location: porcelain throne

PostPosted: Fri Jun 26, 2009 4:43 am    Post subject: Reply to: Help on EXPLAIN -
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Can someone explain me this JCL line ... PeterHolland JCL & VSAM 9 Sat Dec 12, 2015 7:22 am
No new posts DB2 Explain agkshirsagar DB2 3 Wed Aug 28, 2013 6:23 pm
No new posts can some one explain the below code... ram_vizag JCL & VSAM 3 Thu Aug 22, 2013 4:35 pm
No new posts Please explain this SQL CODE. tamminenisidhartha DB2 4 Wed Mar 13, 2013 5:05 pm
No new posts Explain Comparision Report gylbharat DB2 4 Tue Jun 05, 2012 5:48 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us