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
Log in or register to comment.