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
 
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: 25
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 How do you attach a DB2 plan to a CIC... John Poulakos DB2 0 Wed Apr 18, 2018 1:49 am
No new posts How do I define a DB2 plan for a web ... John Poulakos CICS 5 Sat Apr 14, 2018 1:58 am
No new posts VALIDATE option in BIND jcl Poha Eater DB2 2 Mon Feb 26, 2018 7:08 pm
No new posts Finding the plan when code compiled u... Ahemad DB2 2 Fri Dec 01, 2017 6:38 pm
No new posts Where is output from PARM ABEXIT (SNA... packerm CA Products 3 Thu Sep 28, 2017 4:06 pm

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