Answer Posted / s
Packages are single bound DBRMs which contains SQL
statements of a single application program or subroutine.
Before the application program can be executed, you need to
bind a plan. The plan can be bound with DBRM members and/or
Package list. Without the use of packages, if there is any
change made to the program, even if there are no changes to
the SQL, the whole plan need to bound which cause
unavailabilty of the plan and it is resource intensive
since all the unrelated DBRMs are also need to be bound.
With the use of packages, only the package need to be bound
without the need to bind the plan. Also bind parameters can
be specified at package level rather than plan level
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Highlight all the advantages that are attached to a package.
What does db2 blu stand for?
What is coalesce in db2?
Explain packages.
List down the types of triggers in the db2 database?
What os does db2 run on?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the difference between cursor stability and repeatable read isolation levels?
What is the information associated with sysibm.syslinks table?
What is db2 purescale?
Is db2 a mainframe?
What is cloudant database?
What is runstats utility in db2?
How to check table size in db2 sap?
Define buffer pool.