Using disk space effectively

How you allocate and manage data sets, compress your data, and design your indexes can affects the performance of Db2.

Procedure

To use disk space more efficiently, use any of the following approaches:

  • Change your allocation of data sets to keep data sets within primary allocations.
  • Manage them with the Hierarchical Storage Management functional component (DFSMShsm) of DFSMS.
  • Compress your data.
  • Choose a page size that gives you good disk use and I/O performance characteristics.
  • Evaluate the need for and characteristics of your indexes.

What to do next

To manage the use of disk, you can use RMF to monitor how your devices are used. Watch for usage rates that are higher than 30% to 35%, and for disk devices with high activity rates. Log devices can have more than 50% utilization without performance problems.