How to find the size of a COVERED or VIRTUAL area

Document ID : KB000010580
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

The maximum size of a MRDF area can be defined using the COVERED or VIRTUAL MUF startup parameter or when using the COVERED_ADD command.

However it can be useful to know how much memory is actually used for each area.

 

Instructions:

Memory Resident Data Facility Summary Information (M R D F SUMMARY INFORMATION) report generated at MUF EOJ (or by a ALL_INFO_REPORT command) contains the requested info. 

 

The following query returns useful info too:

SELECT DBID, AREA_NAME, DATASPACE, MEMORY_SIZE,
       BLOCKS_MAXIMUM, BLOCKS_CURRENT          
FROM SYSADM.MUF_COVEREDVIRTUAL;   

 

 

Additional Information:

See Memory Resident Data Facility Summary Information report on DocOps for details.