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 is a plan and package in db2?
What is db2 catalog database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is check constraint. Explain with example.
How do I delete a table in db2?
What is ibm db2 used for?
What is runstats and reorg in db2?
How do I import a csv file into db2?
Explain in detail about buffer manager and its functionalities?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is table space in db2?
What is schema in db2?
What is the role of the data page in the db2 database?
How do you find the maximum value in a column in db2?
What is the use of db2 optimizer?