DB2 UDB for z/OS Performance
   The Basics…

Superior Performance is vital

Recent quotes...

Performance is Relative

Performance is like a traffic circle

System Overhead

System Overhead & Performance

Delays & I/O Performance

Opportunities - Eyeball method

DASD Basics

DASD Basics - Definitions

DASD Subsystems
No Silver Bullets...

DASD Subsystems
Performance over time...

DASD Subsystems
Not isolated poor performance...

How bad can poor I/O                performance be?

Good response time - 4K Synch I/O

DASD Subsystems  -  SMF 42-6 data

The Basics Don’t Change

Gotchas…  SMS

Gotchas…  RAID5

Important application
                   performance data

Top down tuning

Top down tuning

Memory requirements

System exception triggers

Buffer Pool Performance

Buffer Pool Performance

System Hit Ratio

I/O Rate/Second is more Important

Buffer Pool Performance

Buffer Pool Performance

Most common problems…                                                             Not in the application

Keys to better performance

The basics of performance...

Slide 35