Plan bind with multiple members

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

If i am binding the plan with multiple cobol members, whic timestamp does the plan will take form dbrm...

for all the programs there will be seperate dbrms with seperate tim,e stamps.. on binding it to one plan, what does the plan wil take?

On runnuing th emainprogram with the plan, how does the matching wil take place in this scenario?

raghunathns · Posted: Fri Sep 22, 2006 1:05 am

you will be having multiple packages. one package to a program. when you bind plan it will bind all packages and it will keep timestamp of all packages. it will check against a perticular program timestamp with perticular package timestamp.

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

yes.. i understood..
but the members alone is binde in a plan not i PKList...

on binding multiple members from the seperate DBRMs to a plan which membrs time stamp does the plan will take

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

surya_pathaus · Active User Joined: 28 Aug 2006 Posts: 110

Hi,

[/quote]
on binding multiple members from the seperate DBRMs to a plan which membrs time stamp does the plan will take

Muthukumar.PLindia · New User Joined: 03 Jul 2006 Posts: 51 Location: Chennai

thanks..

NOw if p1 is the parent of p2 and p2 is the parent of P3
p1->p2->p3

now p3s timestamp will be overidden in the plan

while running the program
run(p1) plan(plname)

if p1 has an sql statement before calling p2, it will look into the plan. But the timestamp for the plan is different from p1 loadlib's timestamp.. then how does it executes the code ...