Answer Posted / rahul nittala
The concept of packages came from this particular problem
which was faced earlier:
when there were no packages, all the dbrms for a respective
program have to be bound directly to the plan. In such
cases, whenever there was any change made to any calling or
called program within the plan, all the modules had to be
bound to their individual dbrm and then all the dbrms had
to be bound to the plan. To avoid this, the concept of
package was introduced which was just an address location
in the memory and not a physical entity. By introducing the
package concept, it was not necessary to bind all the
individual dbrms again, only that module to which change
was done had to be bound to that respective package. There
will be a one - to - one relation between a dbrm and a
package. A package actually stores the address of the dbrm.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is a cursor in programming?
What is role in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is data manager?
What is deadlock in db2?
What is the difference between nvl and coalesce?
What is a plan and package in db2?
Explain packages.
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?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is ibm db2 connect?
What is explain plan in db2?
Why do we need reorg in db2?
What is with ur in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
