DB2 Version 10.1 for Linux, UNIX, and Windows
Troubleshooting optimization
Troubleshooting optimization guidelines and profiles
Diagnostics support for optimization guidelines (passed by optimization profiles) is provided by EXPLAIN tables.