Db2 archive log issues
Another issue about the Db2 archive log is that much of the data within the archive log data set is completely unnecessary for any Db2 forward recovery process. A considerable amount of log data recorded by Db2 is there only to allow any transaction backouts that may be required. After the data has been committed, up to 80 percent of the data recorded in the log is not needed by any Db2 forward recovery process. Also, some Db2 objects may exist within your environment that will never require a Db2 forward recovery involving access to log data. These objects can always be recovered in a recovery to a specified image copy or be re-created by batch processes. However, Db2 does not give you the option to omit logging of the information about such objects.
Data compression of the archive log data sets does allow you to reduce the storage media required to contain the log data. However, IBM recommends that hardware data compression not be used when you store archive log data sets on tape due to the adverse effect on performance when you perform transaction backouts (in cases where archive log data is needed to perform the backout).
Even without data compression, when an application is terminated and archive log data residing on tape is required to allow Db2 to back out the application, the backout process can impose a heavy burden on Db2 resources. DBAs, therefore, must choose between the following two options for storing archive log data sets:
- Storing them on DASD, which allows faster backouts but is more costly
- Storing them uncompressed on tape, which is less expensive but provides slower access for backouts
In an attempt to compromise, many DBAs keep as much data as possible in the active logs, thus increasing the amount of DASD dedicated to Db2 log data.
PACLOG solution
The PACLOG utility provides solutions to Db2 archive log issues. The product provides impressive savings of archive log media along with a set of archive log management functions that include an interactive modeling tool that helps you optimize the number of active logs and their size.
PACLOG achieves media savings in the following ways:
- Replaces log data records not needed by any Db2 recovery process with easily compressible data
- Removes log data for user-specified Db2 objects
- Compresses the log data
- Allows reductions in the size of active log data sets stored on DASD if the archive log data sets reside on DASD instead of tape
PACLOG also offers the following functionality:
- Stores the processed primary and backup archive logs on different device types
- Provides statistical information about the logs and the bootstrap data set (BSDS)
- Provides recovery site primary and backup archive logs in addition to the archive logs that were created by Db2