Monitoring Performance › Using the Statistics and Diagnostics Area (PXX) Report

Using the Statistics and Diagnostics Area (PXX) Report

CA Datacom/DB provides a database statistics report that displays information about:

• Service requests
• Exclusive control
• Buffer availability
• Request wait time frequency
• I/O events

The report consists of three parts, each of which is accumulated and reported on separately:

• System statistics
• I/O statistics
• User request statistics

Look at the number of Index buffers and data buffers used. Be sure there are enough. Look at the CBSBFR SPILL COUNT. If it is high, increase the appropriate MUF startup option CBS value. See the CA Datacom/DB Database and System Administration Guide and CA Datacom/DB DBUTLTY Reference Guide for information about how to use the Statistics and Diagnostics Area report.