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?
search cancel

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?

book

Article ID: 45332

calendar_today

Updated On:

Products

Datacom DATACOM - AD CIS COMMON SERVICES FOR Z/OS 90S SERVICES DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS COMMON PRODUCT SERVICES COMPONENT Common Services CA ECOMETER SERVER COMPONENT FOC Easytrieve Report Generator for Common Services INFOCAI MAINTENANCE IPC UNICENTER JCLCHECK COMMON COMPONENT Mainframe VM Product Manager CHORUS SOFTWARE MANAGER CA ON DEMAND PORTAL CA Service Desk Manager - Unified Self Service PAM CLIENT FOR LINUX ON MAINFRAME MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME GRAPHICAL MANAGEMENT INTERFACE WEB ADMINISTRATOR FOR TOP SECRET Xpertware

Issue/Introduction

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. 

 

Environment

Release: DATABB00200-14-Datacom/AD
Component: