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


Please Help Members By Posting Answers For Below Questions

What is a plan and package in db2?

819


What is db2 catalog database?

773


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2628


What is check constraint. Explain with example.

825


How do I delete a table in db2?

805






What is ibm db2 used for?

807


What is runstats and reorg in db2?

1002


How do I import a csv file into db2?

732


Explain in detail about buffer manager and its functionalities?

763


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?

2258


What is table space in db2?

767


What is schema in db2?

755


What is the role of the data page in the db2 database?

756


How do you find the maximum value in a column in db2?

815


What is the use of db2 optimizer?

795