One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
- 3 Answers
- 17664 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarath
when u precompile a Db2 program you will get (n+1) DBRMs
where n indicates no. of subprograms. So in our case you
will get 6 DBRMs. Through Binding process you can get
minimum of 1 package and maximum of 6 packages. But finally
you will get only one plan.
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / vat
Not trying to be cute, but, to the question "after
precompilation how many plans and packages will
created?" the answer would be zero.
You would have to do bind to even talk about packages/plans.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / snehasis
If it generate 6 DBRM, then there is no possibility to have
1 package. The reason is one package can contain only one
DBRM. But yes for all these DBRM and Packages it will be
only one plan.
| Is This Answer Correct ? | 9 Yes | 3 No |
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
how to identify the pseudo conversation by seeing the program
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is the difference between drop table and delete table?
What is with ur in db2?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What is database manager in db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is the format (internal layout) of ?TIMESTAMP??
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is meant by isolation level?
COBOL 
