Rebind Plans

Go Up to Available object actions by DBMS

This action lets you update the best access path for SQL statements when the contents of a plan change.

Tip: If the physical storage of a plan is changed or dropped, rebinding updates the path of the SQL statements.

Platform Availability

• DB2 z/OS

To Rebind a Plan

• In DBArtisan, click the Rebind button on the Plans tab of the DBRMs editor. For more information, see DBRMs Editor (IBM DB2 Z/OS).

• In DBArtisan, click the Rebind button on the Plans/Packlists tab of the Packages editor. For more information, see Packages Editor (IBM DB2 Z/OS).