Manage Learn to apply best practices and optimize your operations.

Have You Wanted To Know Why Transaction Logging Is So Vital?

When transaction logging is enabled,the Domino R5 Server captures all the changes that users make to databases and writes them to a transaction log, rather than immediately writing them directly to the various databases. This allows Domino to defer write operations to databases during times of high server activity. When resources are available, or at periodic intervals, logged transactions are written to disk in a batch. Should a failure occur in the interim, the transaction log is used to recover the affected databases.

The great advantage of transaction logging is that it allows Domino to automatically recover data lost through system failures simply by replaying the deferred database changes from the transaction log. The principal benefits of this highly efficient data recovery capability are:

Simplified backup procedures. On a daily basis, most sites will need to back up only the transaction logs for that day.

Improved data integrity, because the recovery process detects any missing changes and replays them, while "undoing" any changes that were incomplete at the time of the failure. Thus, Domino can start with "clean" databases.

Much faster server restart times, which means enhanced system availability.

No more long Fixup sessions! With transaction logging, you will rarely need to run Fixup on a logged database, except in the very rare event that Domino detects errors following recovery.

Another benefit of transaction logging is a measurable increase in overall system performance. The logging process creates more total overhead. But Domino more than makes up for it, by writing to the log sequentially, rather than to the databases randomly. This means faster writes!

Transaction logging will:

Save you considerable time, trouble and tape over the long run.

Enable you to deliver a higher level of service.

Save your organization substantial amounts of money through increased up-time, reduced backup costs and better server performance.

Potentially prevent the catastrophic costs associated with losing mission-critical data.

So all you admins out there, look into getting this implemented on your systems and watch the improvements!

Dig Deeper on Domino Resources - Part 2

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...