COLLID bind option

The COLLID option specifies that any DBRMs in a plan are bound to packages. It applies only for rebinds of plans that were created prior to DB2® 10 with DBRMs bound directly into the plan. The resulting packages are bound to the specified plan, and the resulting plan includes only packages. It does not include any DBRMs.

Command option	Option values	Used with
COLLID	(collection-id ) (* )	REBIND PLAN

Option descriptions for COLLID

COLLID(collection-id): Specifies the collection identifier for the new packages.

COLLID(*): Specifies that the default collection identifier, DSN_DEFAULT_COLLID_plan-name, is to be used for the new packages.
If you do not specify COLLID in REBIND PLAN, and the plan was created prior to DB2 10 and has DBRMs bound directly into it, COLLID(*) is in effect.

Catalog records for COLLID

See the following catalog tables: SYSPACKAGE catalog table, SYSPACKAUTH catalog table, SYSPACKDEP catalog table, and SYSPACKSTMT catalog table.