How many DBRMs , Packages and Plans created after Bind

praneethgokul · New User Joined: 06 May 2005 Posts: 20 Location: Bangalore

Hi all,

I have 5 SQL statements in my Cobol-DB2 program.

when I bind it, how many DBRMs , Packages and Plans will be generated?

Please help me out.
:shock:

gnagakishore · New User Joined: 26 Mar 2005 Posts: 25 Location: Hyderabad

one plan will come its sure. but regarding to packages and dbrms its system dependent i think.

muraliksnv · New User Joined: 07 May 2005 Posts: 3

hi all,

how many exceptional conditions can we give in a handle command?

sivatechdrive · Posted: Mon May 09, 2005 12:34 pm

Hi praneethgokul

there will be only 1 DBRM..and 1 plan

the DBRM is based on the program not the number of SQL sttements inside a Program...
if this program calls 3 db2-cobol subprograms then the total number of DBRM's are 4 ( 1 mainprogram + 3 subprograms )

Regards
siva

narasimharao_koganti · New User Joined: 26 Apr 2005 Posts: 11 Location: pune

hi, one dbrm will be generated for one program. if your is calling n- sub-programs then for every sub-progaram there will be n dbrm. i.e., for a program that is calling n programs there will be n+1 dbrms. for one dbrm there may one package or more, but only one plan will be generated.

narasimharao_koganti · New User Joined: 26 Apr 2005 Posts: 11 Location: pune

hi murali,
I think we can specify upto 12 handle conditions, in a handle condition command.