Transactional Logging Improvements

There are a number of improvements to the transactional logging capabilities of DB2. Logging capacity has been increased, along with logging performance. Meanwhile, configuration parameters have been added that enable DBAs to closely control the logging activity of transactions.

Increased Log Space

The maximum amount of log space that can be defined has been increased from 32 GB to 256 GB. This provides support for large numbers of concurrent transactions and database applications that require large transactions.

Infinite Active Log Space

In addition to the increase in the maximum amount of log space, you can enable infinite active log space. In this state, transaction logs are able to span the primary logs ...

Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.