We often have to analyse the performance of DB2 applications. Often we don’t know which SQL is executed, so we have to found out, which SQL is executed against a DB2 DB. We had a look to Spotlight for DB2 and see, that only a smal amount of SQL is collected. If we look inside to DB2 SQL Cache, we see much mor SQL statements. With the Information inside the SQL Cache we then try to EXPLAIN and analyse the performance. Sometimes we use the free tool DB2 monitor from http://chuzhoi_files.trpod.com for this. Is it possible to extend Toad for DB2 to access the SQL Cache and mark a statement for EXPLAIN like inside this tool?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Database - Cache | 2 | 1647 | August 31, 2011 | |
| A new Toad DB2 Beta Installer is now available (v6.1.0.778) | 7 | 1355 | May 27, 2015 | |
| The Toad for DB2 v4.7 Beta Program has started | 0 | 824 | May 25, 2010 | |
| A new Toad for DB2 v5.0 Beta Drop is available | 0 | 735 | July 28, 2011 | |
| A new Toad for DB2 v5.0 Beta Drop is available | 0 | 751 | July 28, 2011 |