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 utility for parm lib
How to restart a DB2 program?
What are bind parameters in db2?
Why do chiropractors use drop table?
Mention the downsides of page level lock.
What is dbrm in db2 database?
How to find schema of a table in db2?
What is the information associated with sysibm.syslinks table?
How to execute stored procedure in db2 command editor?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Is db2 a mainframe?
What is access path in db2?
What is the role of the data page in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
What is a cursor in programming?