DBA > Job Interview Questions > DB2 INTERVIEW QUESTIONS

Can anyone tell me when do we need a COLLECTION?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Can anyone tell me when do we need a COLLECTION? I know the concept of PLAN and PACKAGE, but unable to understand about COLLECTION.

package is normally linked to plan, however Suppose you want that in a same package , some particular sets of SQLs should have different properties and other set should have different properties then you give the collection id option within a package,for eg: if there are 2 queries and i require that 1st query should have isolation level CS to be for 1st query and RR for the second query then u need to give collection id option within the package for these different isolation levels.

Collection is not a property of a plan. Collection is a property of a package. Within a plan there are package lists (PKLIST) which identifies collection and/or packages that are available through that plan.

Collection is to package as schema is to table.

Other Job Interview Questions