Toad World® Forums

Explain DB2 SQL Cache


#1

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?