This chapter discussed performance topics such as how to use DB2 traces and IFCIDs to help diagnose problems in DB2 and how to monitor statistics. Various areas of memory, such as buffer pools, RID pool, EDM pool, sort pool, and dynamic SQL caching, were also discussed. |