Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is Mean By PLAN_TABLE in EXPLAIN

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mahesh_yellale

New User


Joined: 25 Dec 2006
Posts: 3
Location: pune

PostPosted: Wed Mar 07, 2007 3:27 pm    Post subject: What is Mean By PLAN_TABLE in EXPLAIN
Reply with quote

What is mean by PLAN_TBLE in EXPALIN
plz help i am so confused
Back to top
View user's profile Send private message

vini_srcna

Active User


Joined: 26 May 2005
Posts: 178
Location: Copenhagen, Denmark

PostPosted: Wed Mar 07, 2007 5:14 pm    Post subject:
Reply with quote

EXPLAIN is a bind parameter. While binding the application plan you might give the option EXPLAIN(YES). Default is EXPLAIN(NO).

If you give YES it would give the explanation about the queries in the DBRM into a separate table called PLAN_TABLE. The user binding the PLAN needs to have their own table. Later one can query the PLAN table to find out the access paths.

How a particular query is executing..? Is it going for INDEX SCAN or TABLESPACE scan. Is index used effectively or not and much more. Over all this is a huge concept. This comes into picture while during the performance tuning for the applications. You can find much more information in the manual.

If you bind the plan with EXPLAIN(YES) and if there is no explain table existing under your ownership then it would through you the -ve error code mostlikely -219 I guess. Hope this helps you..!! Thanks
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
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us