How to monitor space utilization of Datacom files

Products

• Datacom
• DATACOM - AD
• Datacom/AD
• Datacom/DB

Issue/Introduction

What is the recommended approach to monitor space utilization of Datacom files?

Resolution

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 

Or by running an SQL query using DBSQLPR with the following input:

//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

Additional Information

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 consider running an EXTEND. 

If all 16 extents have been used on the last volume, then the file would need to be reallocated. The recommended approach would be to use Online Area Move (OAM) to avoid minimum disruption. Follow Article 277391 titled"Using the Online Area Move (OAM) process" for more information.