The following is tip #9 from "Managing Lotus Domino servers -- 15 tips in 15 minutes," excerpted from Chapter 14 of the book Lotus Notes and Domino 6 System Administrator Exam Cram 2, published by Sams Publishing.
Transaction logging is available for Lotus Domino servers running release 5 or later and databases using release version 5 or later On Disk Structure (ODS). Database changes are sent to a transaction log database and then written later to the target database. Transaction logging offers benefits for the following system activities:
- Backup throughput is increased because transaction logs back up quicker than normal databases.
- Disaster recovery is more complete in that data that was stored in the transaction log can be supplemented to the full system recovery so data is not lost. Data that is stored in the transaction log file is written to the database when the log file is recovered from tape.
- Database views are stored in the log file so database views may not need to be rebuilt.
Transactional logging also creates a unique database instance ID (DBIID) for each database. When transactions are added to the log, the DBIID is assigned so that the source database can be recorded. DBIID tags are assigned at the following times:
- The first time transaction logging occurs.
- In some instances when the Compact task is executed, such as reducing file size.
- When fixup is used to correct a corrupted database.
- When a database is moved to a server using transaction logging.
Transaction logging versions
You can choose from three different versions of transaction logging, including Circular, Linear, and Archived. Here are descriptions of each of these transaction logging versions:
- Circular: This version of logging uses up to 4GB of disk space and then begins writing over the oldest log information in the database. The transaction log database should be backed up daily using this deployment version.
- Linear: This version of logging is similar to circular logging, but can use more than 4GB of disk space.
- Archived: This version of logging creates transaction logs as needed. Log files are not overwritten; they are archived. Ensure that the logs are being backed up regularly or the server might run out of disk space.
Implementing transaction logging
Transaction logging needs to be properly planned before it can be implemented. Steps to complete before implementing transaction logging include:
- Make sure the server hardware is properly configured. Use a disk array with at least RAID 1 support and a dedicated disk controller.
- Define a backup plan and use software that supports Domino servers running transaction logging.
- Plan to use logging on all available databases, but remember that only databases using the R5 ODS or later will be able to use transaction logging.
- Decide which version of logging to use (Circular, Linear, or Archived).
To set up transaction logging on the server, follow these steps:
- Using the Domino Administrator, select the Configuration tab, select the Server document, and then click Edit Server Document.
- Select the Transactional Logging tab.
- In the Transactional Logging field, select either Enabled or Disabled.
- In the Log Path field, enter the explicit path to the transaction log database.
- In the Logging Style field, select either Circular, Linear, or Archived.
- The default selection for the Use All Available Space On Log Device is No. If you use the default selection, in the Maximum Log Space field, enter the amount of space in megabytes to be used for the transaction log database.
If you select Yes in the Use All Available Space On Log Device field, the next option, Maximum Log Space, is removed as a valid selection.
- Choose Enabled or Disabled in the Automatic Fixup Of Corrupt Databases field. If Automatic Fixup is not enabled, administrators will need to manually perform database maintenance when errors occur.
- In the Runtime/Restart Performance field, choose from the valid options in the drop down menu: Favor Runtime, Standard, and Favor Restart Recovery Time.
- In the Quota Enforcement field, choose from these valid options:
- Check Space Used in File when Adding a Note
- Check Filesize when Extending the File
- Check Filesize when Adding a Note
- Select Save & Close to start transaction logging.
Managing Lotus Domino servers
Tip 1: Activity logging on your Lotus Domino server
Tip 2: Applying policy documents on your Lotus Domino server
Tip 3: Automating Lotus Domino server tasks
Tip 4: Changing access levels on your Lotus Domino server
Tip 5: Configuring Domino network names on your Lotus Domino server
Tip 6: Decommissioning a Lotus Domino server
Tip 7: Defining a backup process and Domino domains
Tip 8: Enabling protocols on your Lotus Domino server
Tip 9: Enabling transaction logging on your Lotus Domino server
Tip 10: Identifying a registration server on your Lotus Domino server
Tip 11: Implementing directories on your Lotus Domino server
Tip 12: Recertifying a Lotus Domino server ID
Tip 13: Using the Domain Search tool on your Lotus Domino server
Tip 14: Setting up authentications on your Lotus Domino server
Tip 15: Prepare for your Lotus Domino server exam
This chapter excerpt from Lotus Notes and Domino 6 System Administrator Exam Cram 2, by Karen Fishwick and Tony Aveyard, is printed with permission from Sams Publishing, Copyright 2005. Click here for the chapter download.