Rohit Agni

• Oct 27th, 2005

 

Hi

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.

Pl. correct me if i am wrong.

Rohit

nate

• Dec 5th, 2005

 

within a plan, there is a collection and within that collection there are packages.

Bharathy

• Dec 23rd, 2005

 

May be this link helps you:

http://www.db2mag.com/showArticle.jhtml?articleID=15300107

Culver_lake

 Profile Answers by Culver_lake 

• Mar 18th, 2006

 

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.

sethy.pradeep

 Profile Answers by sethy.pradeep 

• Nov 18th, 2008

 

Collection is generally used for grouping of db2 packages.For each collection there is one collection id should be created.

sethy.pradeep

 Profile Answers by sethy.pradeep 

• Nov 18th, 2008

 

Collection means grouping of db2 packages.