Article ID: 124851


Updated On:


CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware


How can you determine what areas should be defined as Memory Resident Data Facility (MRDF) COVERED and what COVERED option to specify, FIRST or ACTIVE?

The Memory Resident Data Facility allows areas to be defined as COVERED to keep data blocks resident in memory. This reduces the amount of physical read I/Os to that area and increases response time as there is less time spent in doing physical I/O which in turn reduces CPU usage.


Component: DB


Candidate areas to be defined as COVERED are areas with the highest read count. Out of these areas then select the ones that belong to critical applications or applications that have poor performance. There are SQL queries in KB000055147 to help determine which areas will benefit most from being covered in terms of the I/O saved.

Another consideration is how much 64 bit storage is available and how much can be allocated to COVERED areas.

The COVERED FIRST option uses less memory and CPU because it is easier to manage but is only useful if the first part of the area is accessed the most.

The COVERED ACTIVE option would be better specially if only a small portion of the area is COVERED.

If you don't know how the area is used then start by allocating a portion of the area to COVERED ACTIVE and then look at the MRDF statistics to see if any benefit has been gained and adjust accordingly. Again use the SQL queries in KB000055147 to see the MRDF statistics. This is the normal procedure you would follow with any tuning exercise.

Additional Information


KB000055147 - How do I determine which data/index areas are the best candidates to be implemented as covered

Video Performance Tuning in the ‘real world’ Part 1 , the COVERED part is around minute 34.

PDF for Performance Tuning in the ‘real world’ Part 1