Rebind Plans
Go Up to [[Available object actions by DBMS{{#if:||{{{2}}}}}]]
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
To Rebind a Plan
<l s="dbartisan" />
- In DBArtisan, click the Rebind button on the Plans tab of the DBRMs editor. For more information, see DBRMs Editor (IBM DB2 Z/OS).
<l e="dbartisan" />
- 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).