DB2 LUW Cancun Release New Explain Information

The DB2 10.5 “Cancun Release” was previously available as DB2 LUW Version 10.5 Fix Pak 4. The short list of prerequisites and summary DB2 10.5 “Cancun Release” features list is here at the IBM DB2 10.5 “Cancun Release” Fix Pak Knowledge Center website. Within the release there are many important features, and some . . . → Read More: DB2 10.5 “Cancun Release” New Explain Information

Discovering DB2 Access Using the Explain Plan Table

While reviewing a clients’ DB2 performance issues, we researched the SQL that was being executed against a table on a daily basis by analyzing the DB2 access methods with the plan table. The DB2 access methods are captured at compile and bind time through the explain process. Its output is available in the plan table. . . . → Read More: Discovering DB2 Access Using the Explain Plan Table