We use Explain to find out the access path for a new query or when you Bind a package. Jim Dee, BMC Software's Chief Architect for DB2 for z/OS shows you how you can compare the access path with previous versions of the query or package – comparing the estimated costs, and identifying those that have changed with a rebind due to a new DB2 version, change in statistics or even a change to the code.
Recent releases of DB2 have enhanced the Explain facility and have provided Access Path Stability. Jim will show you how to take advantage of these features. His article can be found here: