Introduction:

ADC mail-in db is configured with Domino server to collect fault report and logs from various notes client/server workstation whenever any fault (crash/hang) occurs. As the fault is received by mail-in database, the size of database keeps on growing and reaches to maximum limit. This article will explain the steps to give correct entries in Domino's notes.ini so that Domino's add-in task Faultanalyzer will delete attachments of child faults to reduce the ADC db size.

Prerequisites:

1. Installed Domino Server(9.0)
2. ADC database configured on the server to receive faults
3. Domino Administrator
4. Administrator access to the machines with the above configurations.

Change in Domino's notes.ini:

To start, you first need to enable size reduction feature by adding entries of selection criteria in notes.ini file. There are two ways to set the criteria to reduce the size of db by deleting attachments of child faults. Following are the two notes.ini entries to define criteria:

FAULT_ANALYZER_SRA_DAYS_OLD

FAULT_ANALYZER_SRA_FORMULA

Setting FAULT_ANALYZER_SRA_DAYS_OLD:

To delete the attachments of child faults, you need to specify number of days old faults to be considered. For example you have faults in you ADC db more than one years old and wants to delete attachments of child faults which are older that 100 days.

To accomplish we need to add following entry in the notes.ini:

FAULT_ANALYZER_SRA_DAYS_OLD=100

As soon as the Domino server will start/restart the faultanalyzer will delete attachments of child faults based on above criteria.

Setting FAULT_ANALYZER_SRA_FORMULA:

In previous criteria setting, its has predefined rule to delete all faults having x number of days old. If you want to delete the attachments of child faults with some other criteria, it is be possible by setting formula. This entry allows you to define criteria which satisfies formula language. For example if you want to delete all the attachments of child fault of a specific release/build, you need to set formula as:

FAULT_ANALYZER_SRA_FORMULA=@IsMember(Version;"Release 7.0 HF277 June 21, 2006")

Note:If both the entries are set, the second one will take higher priority (i.e. FAULT_ANALYZER_SRA_FORMULA).

Frequency to reduce the size of ADC db:

Once the entries are set and Domino server get started, the faultanalzer starts deletion of the attachments of child faults immediately and repeats on every 7 days interval i.e. weekly.

Steps to reduce on-disk size:

Once the attachments get deleted, the reduction in db size on disk will be reflected only when you will compact the db. Following are the steps to compact the database:

1. Go to the database properties and select second tab

2. Click on the button 'Compact' as highlighted in below image

3. Once the compaction is done, you can check the reduced size on disk

 

 

Conclusion:

Before applying above method, make sure that faults are present in the database and satisfies the formula to delete the attachments of child faults otherwise there would not be any effect on existing faults. Giving value of any of the above entries, the size reduction feature will automatically enabled. After enabling the feature, the size of database will increase slowly because measure part of the size is consumed by attachments. On first run the db size could be reduced upto 70%.

Resources:

http://www.ibm.com/developerworks/lotus/library/domino7-serviceability/

About the Author:

Manish Singh is a Senior Software Engineer working in Pune, India Software Lab of IBM. Manish has been a developer on the IBM Notes Client serviceability since May 2012. You can reach him at manish_singh@in.ibm.com.