 |
 |
SPT01 Transparency strengthens Package Stability and allows customers to benefit from its usage without the risk of falling back to surprising performance results. SPT01 Transparency reads the information about existing copies of a package directly from SPT01. Within its online interface, you can see the information about the active, previous, and original generations of a package and drill down to the access paths on the SQL statement level. This provides the access path visibility you need to decide which access path you might want to switch to. SPT01 Transparency automation generates the necessary REBIND SWITCH command based on the access path copy you select. If you need to delete package copies, e.g., to save a new original, SPT01 Transparency also generates the desired PLANMGMT SCOPE command as well. An intelligent cleanup procedure for PLAN_TABLEs and other DSN_* tables keeps the Visible Access Paths for all copies of a package that exists in SPT01. All information is externalized into a DB2 table that can be input for existing procedures. With SPT01 Transparency, you have the visibility you need to exploit Package Stability and make "performance-wise" decisions.
| ||||