View previous topic :: View next topic
|
Author |
Message |
skkp2006
New User
Joined: 14 Jul 2006 Posts: 93 Location: Chennai,India
|
|
|
|
Can we have the same plan for two DB2 programs ????
like when u execute the program i can do like below
//SYSTSIN DD *
DSN SYSTEM(DB2E)
RUN PROGRAM(GRXGR0) PLAN(GRXGR0)
/*
and
//SYSTSIN DD *
DSN SYSTEM(DB2E)
RUN PROGRAM(GRXGR12) PLAN(GRXGR0)
/*
and execute GRXGR0 and GRXGR12 from the same plan ???
and if we are calling a DB2 program from a non db2 program should we have a plan for the calling program.... Say A is non db2 calling B which is DB2 should we have plan for A ??
Thanks and Regards,
Syam |
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
Hi
i) You can have same plan for two programs if the corresponing packages of the program are available under that plan.
ii) Separate Plan is not required for the calling program(i,e) Non-DB2 program.
Sai |
|
Back to top |
|
|
|