DB2 System Performance Metrics Revisited

DB2 System Performance Metrics Re-Visited

We Care about Performance Data

New Complexities….

Tuning with Version 3 and Later..

Sixty BufferPools

CPU and I/O Parallelism

Data Compression

Data – Data…. Where is the Performance Data …

Data – Data…. Where is the Data Other Sources

DB2 Records…. What is all this data?

Where are the Costs Charged….

Where are the costs charged….

Database Manager Address Space

System Services Address Space

IRLM Considerations

DB2 System Performance….

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

Buffer Pool Performance

BufferPool Statistical Analysis

BufferPool Statistical Analysis

BufferPool Statistical Analysis

Application Effects of BufferPool Tuning

Logging Considerations….

DASD Performance

DASD Performance

DASD Performance

DASD Performance

DASD Performance

DASD Performance

Any Questions…..