CollectionID

For Db2, the CollectionID parameter specifies a collection name that the High-speed Apply Engine uses in any BIND PACKAGE or FREE PACKAGE commands that it issues.

Attributes

This parameter has the following attributes:

Usage

Use this parameter to limit the scope of the authority that you must grant to either:

• The user ID that runs High-speed Apply Engine

• A different user ID (possibly a secondary authorization ID) that the High-speed Apply Engine uses to administer collections.

How you use this parameter depends on how you grant Db2 authority for High-speed Apply Engine to administer collections. For more information, see Db2 authorizations for plans, packages, and collections.

The BMC Software product LOADPLUS for DB2 passes the value of the APCOLLECTION option to High-speed Apply Engine as the CollectionID parameter during an SQLAPPLY load action. For more information, see Integrating.

High-speed Apply Engine generates collection names as follows:

• If you specify a value for this parameter, High-speed Apply Engine creates only the collection name you enter. You can grant either user ID listed in the preceding paragraphs authority over only the specific collection name you enter.

• If you do not specify a value, High-speed Apply Engine uses the current plan name as a collection ID. If you specify the PlanName parameter (PlanName), you can grant either user ID authority over only the collection with the same name as the plan name.

• If you do not specify either the CollectionID or PlanName parameters, High-speed Apply Engine dynamically generates a plan name and uses that plan name as a collection name. Because you cannot predict the generated plan name, you might need to grant either user ID authority over all collections. Many Db2 security environments do not permit this type of operation.