Interested to Buy Any Domain ? << Click Here >> for more details...
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
Which isolation level provides highest data integrity?
What is the connection string to connect to the DB2 Database ?
How do I delete a table in database?
What is cascading rollback?
What is a system catalog table in db2?
What is lock escalation in db2?
Why do we use cursor?
What is the difference between spufi and qmf?
What is the maximum number of columns in a db2 table?
what is db2 restart?
What is the latest version of ibm db2?
What do you mean by storage group (stogroup)?
Discuss about db2 bind?
What is the use of reorg in db2?
What is a bind in db2?
