Typically, when SQL statements are added, removed, or modified
in a source program, you must rebind the related DB2® package by running the BIND command
with the ACTION(REPLACE) suboption. Running this
command might change the access plan for the SQL statements and affect
performance.
In this scenario, you can compare access plans for SQL statements
from packages to determine if performance has regressed or improved.
Tip: You should specify as the source a collection
(that is, a group of packages) that contains the access plan and packages
from before the SQL statement changes were made. You should specify
as the target a collection that contains the access plans
and packages from after SQL statement changes were made.