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
 

 

EXPLAIN(YES) Option in Plan

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

New User


Joined: 14 Apr 2006
Posts: 25
Location: Banglore,India

PostPosted: Tue Jul 29, 2008 11:25 am    Post subject: EXPLAIN(YES) Option in Plan
Reply with quote

Hi,

We are calling Stored Proc from another region using call statement in our program. SP opens a cursor which is being fetched by our program. DBA has made below plan having two package : - 1. To bind local package & 2. To bind remote package.

BIND PLAN(XA60400) -
PKLIST(CE1_XA.XA60400, -
IPCMDB2H.CE1_XA.XA60400) -
ISOLATION(CS) -
VALIDATE(BIND) -
ACQUIRE(USE) -
RELEASE(COMMIT) -
FLAG(I) -
EXPLAIN(YES) -
RETAIN -
ACTION(REPLACE)

I want to understand EXPLAIN(YES) option when you have remote package. My DBA is not certain about this. But we had previous example where Chgman job got fail while plan bind.
I do understand that explain defines the access path but wanted to confirm whether it will work in case of remote package or not. It would be great help if anyone can share his/her comments on this.

Thanks in advance !!
Back to top
View user's profile Send private message

sudhakar84

New User


Joined: 20 Jun 2008
Posts: 21
Location: chennai

PostPosted: Tue Jul 29, 2008 1:13 pm    Post subject: Reply to: EXPLAIN(YES) Option in Plan
Reply with quote

Hi,

The explain option is to feed the plan table.
The plan table is used to analyse the cost of the particular query based on the CPU,no of HITs, etc..

Plz refer http://www.gtsm.com/oscon2003/ops.html
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 Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Compiler option for override the exte... muralikrishnan_new COBOL Programming 9 Fri Jul 08, 2016 12:09 pm
No new posts ICETOOL higher option Anshul Das DFSORT/ICETOOL 14 Thu Apr 14, 2016 8:00 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us