What is a collection?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
A user defined name that is the anchor for packages. It has
not physical existence. Main usage is to group packages.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mehdee
Collection is not an actual, physical database object.
Collection is a grouping of DB2 packages.
All packages reside in administrative units called
collections.
PLAN is an executable module containing the access path
logic to one or more DBRMs
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
collection is a group of packages.
package is collection of plan.
| Is This Answer Correct ? | 1 Yes | 5 No |
What is a trigger in the db2 database?
Is Cursor exicutable ?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
Mention and explain the contention situations caused by locks?
What is the reason behind not using select * in embedded sql programs?
What is an asychronous write?
What is db2 instance?
What is buffer pool and list some of them?
What is a plan and package in db2?
what is the maximum number of tables that can be joined ?
What is the difference between plan and package in db2?
Which transaction use a command thread ?