Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at
the time of compilation should plan and package will be
created for both A and B or only B? What is the concept?
Answer Posted / pawan
First thing need to know is whenever we compile any module
only package gets created for particular module. And more
than 1 package can be bounded to single Plan. Here package
will be created for pgm b only and need to bind it to plan
thats it.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is netezza database?
What is db2 plan table?
What does db2 plan contain?
Explain in brief how does db2 determine what lock-size to use?
What action db2 takes when a program aborts in the middle of a transaction?
What is a bind card?
How to test SQL -911 error while developing COB-DB2 program
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Outputs of explain are with matchcols = 0. What does this signify?
What is the difference between plan and package in db2?
Can you use max on a char column?
Explain about open switch business continuity software?
What is an instance database?
What is buffer pool?
Explain various types of locks in db2?