Howmany DBRMs,PACKAGEs and PLANs are created



IBM's flagship relational database management system

Howmany DBRMs,PACKAGEs and PLANs are created

Postby michelmadhan » Wed Mar 30, 2011 1:34 pm

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 ?
michelmadhan
 
Posts: 5
Joined: Wed Mar 30, 2011 1:04 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Howmany DBRMs,PACKAGEs and PLANs are created

Postby DFSHDC40 » Thu Mar 31, 2011 3:37 am

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
If the code hasn't been changed, why is the LKED date today?
User avatar
DFSHDC40
 
Posts: 41
Joined: Sat Oct 16, 2010 4:16 pm
Location: IMS.SDFSRESL
Has thanked: 0 time
Been thanked: 0 time

Re: Howmany DBRMs,PACKAGEs and PLANs are created

Postby michelmadhan » Thu Mar 31, 2011 10:21 am

Thanks for your reply.
But I need some more detail explaination.
michelmadhan
 
Posts: 5
Joined: Wed Mar 30, 2011 1:04 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Howmany DBRMs,PACKAGEs and PLANs are created

Postby enrico-sorichetti » Thu Mar 31, 2011 12:31 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3003
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Howmany DBRMs,PACKAGEs and PLANs are created

Postby michelmadhan » Sat Apr 02, 2011 1:31 am

Thanks for great replay :shock:
michelmadhan
 
Posts: 5
Joined: Wed Mar 30, 2011 1:04 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post