Number of DBRM's formed..

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

Hi..
This was the question asked to me..

If we have prog A and Prog B in such a way that prog A calls Prog B..
how many DBRM's will be formed after precompilation.??

Prog A does not contain any sql statements..all the sql's are present in Prog B.

PeterHolland · Posted: Wed Apr 21, 2010 1:17 pm

DBRM: DataBase Request Module, has the SQL statements extracted from the host language program by the pre-compiler.
PLAN: A result of the BIND process. It has the executable code for the SQL statements in the DBRM.

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

Hi PeterHolland
u mean to say ...only one DBRM will be formed after precompilation..?

PeterHolland · Posted: Wed Apr 21, 2010 1:29 pm

That is what i assume. But im not a DB2 programmer.

Pravesh · New User Joined: 30 Jul 2009 Posts: 32 Location: Gurgaon

whenever we have multiple Db2 cobol porgarms, we plan to have one just cobol pgm(sayA) which calls remaining db2 cobol pgms(say B,C). We will have B and C packages(after binding DBRMs) and one plan with name A.

Regards,
Pravesh

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

Hi Parvesh ..
thx for ur reply..
as far as i understand DBRM is the extracted sql statements by the precompiler ...but if we dont have any sql statement in the calling program..then will the precompiler make a DBRM for the same?

Please correct me if wrong..

Pravesh · New User Joined: 30 Jul 2009 Posts: 32 Location: Gurgaon

no if we do not have any SQL statement in our program, there will not be any DBRM created

Regards,
Pravesh

LearningDb2 · New User Joined: 19 Jun 2009 Posts: 40 Location: India

ok.thx Parvesh..