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
 

 

Plan bind with multiple members

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

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Thu Sep 21, 2006 2:12 pm    Post subject: Plan bind with multiple members
Reply with quote

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?
Back to top
View user's profile Send private message

raghunathns

Active User


Joined: 08 Dec 2005
Posts: 127
Location: rochester

PostPosted: Fri Sep 22, 2006 1:05 am    Post subject: Plan bind with multiple members
Reply with quote

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.
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Fri Sep 22, 2006 6:26 pm    Post subject: Re: Plan bind with multiple members
Reply with quote

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
Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Mon Oct 30, 2006 2:59 pm    Post subject: Re: Plan bind with multiple members
Reply with quote

Muthukumar.PLindia wrote:

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


can anybody help me in this query..
Back to top
View user's profile Send private message
surya_pathaus

Active User


Joined: 28 Aug 2006
Posts: 110

PostPosted: Tue Oct 31, 2006 6:45 pm    Post subject: Re: Plan bind with multiple members
Reply with quote

Hi,


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


Plan bind will override the previous bind. Current Program timestamp will be taken by plan.

For example
P1, P2,P3 are binded with the same plan in a sequence. Now P3 Timestamp will be taken by plan.

Back to top
View user's profile Send private message
Muthukumar.PLindia

New User


Joined: 03 Jul 2006
Posts: 51
Location: Chennai

PostPosted: Tue Oct 31, 2006 9:18 pm    Post subject: Re: Plan bind with multiple members
Reply with quote

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 ...
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 Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Validating file with multiple header/... mohitsaini DFSORT/ICETOOL 6 Thu Apr 13, 2017 1:53 am
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Unable to catalog a gdg dataset resid... Shovan JCL & VSAM 7 Fri Mar 24, 2017 2:24 pm


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