Joined: 17 Oct 2004 Posts: 190 Location: hyderabad
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 )
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.