OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4

Chapter 6. Custom Database Monitor Analysis 183

Example 6-4 shows a query with some of the most commonly used columns in the 3002

record.

Example 6-4 Common columns in the 3002 record

SELECT qqucnt, qqc16 as "QQC16 Index Reused"

,qqptfn as "QQPTFN Table Name"

,qqptln as "QQPTLN Schema"

,qqtotr as "QQTOTR Rows"

,qqridx as "QQRIDX Entries in Temp Idx"

,qq1000 as "QQ1000 Key columns"

FROM mydbmon

WHERE QQRID = 3002

ORDER BY 6

Desc;

Figure 6-5 shows the result of the query in Example 6-4. It shows the following information:

򐂰 In the data sampled, we found the largest indexes, 600,572 entries, that were created for

table ORDERS using SHIPDATE as the key field. ...