Interested to Buy Any Domain ? << Click Here >> for more details...
One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
- 3 Answers
- 18510 Views
- I also Faced
- E-Mail Answers
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
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 a db2 schema?
Is it possible using max on a char column?
What is buffer pool in the db2 database?
What is runstats utility in db2?
What is the purpose of using commit?
What is difference between rollback and commit?
What are the contents of dclgen?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are iseries servers?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is the advantage in De-normalizing tables in DB2?
What is check constraint. Explain with example.
What is nvl in db2?
Which is faster delete or truncate?
