One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
Answer Posted / 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 |
Post New Answer View All Answers
What are the full forms of spufi and dclgen and why are they used?
What does sqlcabc has?
What is the maximum size of varchar data type in db2?
What is the maximum No of rows per page?
Define db2 and its databases?
What is reorg and runstats in db2?
What is deadlock in db2?
What is table space in db2?
How many databases are there?
Outputs of explain are with matchcols = 0. What does this signify?
what is utility for parm lib
can all users have the privilage to use the sql statement select * (dml)?
What does runstats do in db2?
Is db2 a mainframe database?
What is the function of logging in the db2 database?