View previous topic :: View next topic
|
Author |
Message |
shell100
New User
Joined: 14 Apr 2006 Posts: 25 Location: Banglore,India
|
|
|
|
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 |
|
|
sudhakar84
New User
Joined: 20 Jun 2008 Posts: 25 Location: chennai
|
|
|
|
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 www.gtsm.com/oscon2003/ops.html |
|
Back to top |
|
|
|