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?
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:
If you have the SQL option you can get the same information by running DBSQLPR with the following SQL command:
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.