EXPLAIN Explained: Recent Changes That Let Us Use EXPLAIN Better

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

Recent Stories
Db2 for z/OS Native REST API

A RESTful Introduction

DB2 lightweight data analysis for DB2 v9.7 and DB2 v10.1 on AIX and LINUX OS