Page 1 of 1

Howmany DBRMs,PACKAGEs and PLANs are created

PostPosted: Wed Mar 30, 2011 1:34 pm
by michelmadhan
I have two questions on COBOL + DB2 program.
i) If you execute a program that is program-A calls program-B and program-B calls program-C then howmany DBRMs,PACKAGEs and PLANs are created ?
ii) If you execute program-A, program-B and program-c which are individual programs then howmany DBRMs,PACKAGEs and PLANs are created ?

Re: Howmany DBRMs,PACKAGEs and PLANs are created

PostPosted: Thu Mar 31, 2011 3:37 am
by DFSHDC40
i) 1 plan the rest depend how many access DB2 , and how you bind - at least until DB2 10
ii) anything from 1 to 3 plans again depending on how you bind
- but you will always have 3 DBRMs .... what you do with them is down to you

Re: Howmany DBRMs,PACKAGEs and PLANs are created

PostPosted: Thu Mar 31, 2011 10:21 am
by michelmadhan
Thanks for your reply.
But I need some more detail explaination.

Re: Howmany DBRMs,PACKAGEs and PLANs are created

PostPosted: Thu Mar 31, 2011 12:31 pm
by enrico-sorichetti
You can find the detailed explanation in the manuals,
no reason to rewrite what has already been written and is there just waiting to be read!

http://publibz.boulder.ibm.com/cgi-bin/ ... s/DSNSHKA3

Re: Howmany DBRMs,PACKAGEs and PLANs are created

PostPosted: Sat Apr 02, 2011 1:31 am
by michelmadhan
Thanks for great replay :shock: