How can I monitor space utilization of my Datacom files and what percentage should we be looking at to consider the need to extend the area?

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

Question: 

How can I monitor space utilization of my Datacom files? 

What percentage should we be looking at to consider the need to extend the area?

 

Answer: 

Reporting On Space Utilization

You can obtain the space utilization for an area by running a CXX Space Utilization Report. Run DBUTLTY with the following input: 

REPORT AREA=CXX,DBID=nnn,TYPE=A 

 

If you have the SQL option you can get the same information by running DBSQLPR with the following SQL command: 

//SQLEXEC EXEC PGM=DBSQLPR, 
// PARM='PRTWIDTH=999,INPUTWIDTH=72,PAGELEN=56' 
//* 
//STEPLIB DD DSN=DATACOM.CUSLIB,DISP=SHR 
// DD DSN=DATACOM.CABDLOAD,DISP=SHR    <<< CAAXLOAD for CA Datacom/AD
//* 
//SYSUDUMP DD SYSOUT=* 
//SYSPRINT DD SYSOUT=* 
//STDERR DD SYSOUT=* 
//STDOUT DD SYSOUT=* 
//OPTIONS DD * 
AUTHID=SYSUSR 
/* 
//SYSIN DD * 
SELECT DBID AS "BASE ID", AREA_NAME "AREA", DATASET_NAME, 
IN_USE_BLOCKS AS "USED BLOCKS", 
MAX_USED_BLOCKS AS "MAX BLOCKS", 
TOTAL_BLOCKS AS "ALLOCATED BLOCKS", 
DECIMAL((DECIMAL(IN_USE_BLOCKS,10,2) * 100 / 
DECIMAL(TOTAL_BLOCKS,10,2)),10,2) 
AS "%FULL" 
FROM SYSADM.DIR_DATASET WHERE DBID = nnn

 

When To Extend The Area

Datacom will attempt a dynamic extend if the area becomes full provided it has been defined in the CXX to automatically extend. However, sometimes the extend will fail if there is no space left in the disk or if the file has reached 16 extents. 

If the space utilization reaches more than 90%, then you should consider running an EXTEND.