DISALLOW_DEFAULT_COLLID in macro DSN6SPRM

Valid values are YES and NO.

A value of YES has the following implications:

• The BIND PLAN command cannot be used with the MEMBER option. When this setting is used, any attempt to use the BIND PLAN command with the MEMBER option fails.
• The REBIND PLAN command cannot be used without the COLLID option or COLLID (*) specified if the plan has directly bound DBRMs. When this setting is in effect, use the COLLID option to specify a collection ID for the directly bound DBRMs.
• Automatic rebinds do not convert existing plans that were last bound from DBRMs; such attempts fail with a negative SQLCODE.

A value of NO has the following implications:

• The BIND PLAN command is not restricted from honoring the use of the MEMBER option. When this setting is used and a BIND PLAN statement contains the MEMBER option, DB2® first binds the specified DBRM as a package in a collection ID that is named DSN_DEFAULT_COLLID_plan-name. DB2 then binds the plan (plan-name) from that collection ID.
• The REBIND PLAN command can be used with or without the COLLID option or COLLID(*) specified. When this setting is used and the plan has directly bound DBRMs, DB2 first binds the DBRM as a package in a collection ID that is named DSN_DEFAULT_COLLID_plan-name. DB2 then rebinds the plan (plan-name) from that collection ID.
• Automatic rebinds can convert existing plans that were bound from DBRMs into packages from which those plans are then rebound. When an automatic rebind of a plan occurs and that plan was bound directly from a DBRM, DB2 first converts the plan into a package in a collection ID that is named DSN_DEFAULT_COLLID_plan-name. DB2 then rebinds the plan (plan-name) from that collection ID.

The default value of DISALLOW_DEFAULT_COLLID is NO.