Using PACLOG to conserve disk space

A major benefit of the PACLOG utility is the conservation of disk space. This space conservation results from increased flexibility in the allocation of such space to Db2 logs. Because the utility can reduce the size of the archive log by a considerable amount (up to 95 percent or more), it becomes feasible to keep archive logs on disk, thereby making it possible to reduce the number and size of the active logs.

The precise active log size that is optimal for your Db2 subsystem depends on the following factors:

  • Number of hours of active or archive log kept on disk

  • Number of archive logs kept on disk

  • Number of active logs

  • Number of days covered by the BSDS

  • Number of archive logs recorded in the BSDS

  • Average logging rates

  • Whether you use a 3380 or 3390 disk device

  • Expected log size reduction factor due to removed records and data compression

The number of variables makes manual methods of determining an optimal active log size unattractive. To show the impact of using PACLOG and to determine the optimal size for your logs, a modeling tool is supplied with the utility. The modeling tool is described in Using the PACLOG logging environment modeling tool.

Was this page helpful? Yes No Submitting... Thank you

Comments