Identify SQL performance changes due to adding, removing, or modifying SQL statements

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.

Feedback