Reviewing Datacom Buffer ratio and Requests per I/O

Products

• Datacom
• Datacom/DB
• Datacom/AD

Issue/Introduction

In looking at the Datacom tuning with PXX Summary Statistics report, what is a good range for Requests per Total I/O?

When looking at each of the four buffer pools--IXX, DXX, DATANO, DATANO2--what is a good Used5+/Used1 ratio to aim for?

Resolution

There is no recommended value for Requests per Total I/O. This varies form site to site.  

For the ratio of Used5+/Used1, the higher the better. Initially aim for the following targets:

• IXX - 1000+
• DXX - 500+
• DATANO - 50+
• DATANO2 - 50+

Additional Information

See the webcast CA-Datacom Database Tuning 102: DB Performance Analysis in Datacom Video and Recorded Webcast Index and CTC2016 CTC25 Performance Tuning in the CADRE Community.