COLLID bind option

The COLLID option specifies that any DBRMs in the plan are to be bound to packages.

COLLID

(collection-id )
( * )

On: REBIND PLAN

The resulting packages are then bound to the specified plan. The resulting plan includes only packages. It does not include any DBRMs.

The COLLID option applies to only those plans that were created prior to DB2® 10 and have DBRMs bound directly into the plan.

collection-id: Specifies the collection identifier for the new packages.

*

Specifies that the default collection identifier, DSN_DEFAULT_COLLID_plan-name, is to be used for the new packages.

Start of change When COLLID(*) is specified, subsystem parameter DISALLOW_DEFAULT_COLLID must be set to NO for REBIND to be successful. End of change

Start of change 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. End of change

Catalog record: Tables SYSPACKAGE, SYSPACKAUTH, SYSPACKDEP, SYSPACKSTMT, and SYSPACKSYSTEM.