A nice little tool will be shipped with Domino 9 called “database maintenance tool”.
Excerpt from the release notes:
In this beta release, you can take advantage of a new tool for performing multiple daily/weekly administrative tasks on user’s mail database files. The dbmt tool does all of the following:
- runs copy-style compact operations
- purges deletion stubs
- expires soft deleted entries
- updates views
- reorganizes folders
- merges full-text indexes
- updates unread lists
- ensures that critical views are created for failover
Important: When you run this tool, you no longer need to run updall; do not run them both.
This tool is great, because you can define many parameters like a range when to start and stop the tasks.
-compactThreads n: Configures the number of threads for compact
-updallThreads n: Configures the number of threads for updall
-ftiThreads n: Configures the number of threads for rebuilding of the full text indexes
-range <starttime> <stoptime>: The dbmt tool sleeps until starttime and performs compact operations until stoptime (or all databases have been processed), at which point the dbmt tool sleeps until starttime)
-compactNdays n: This option tries to compact all non-system databases every n days
-ftiNdays n: Rebuilds full text indexes every n days. Default is to rebuild them only when they are corrupt
-force d : Selects the day of week to perform fixup on databases that may be having issues compacting. If d is 0 (zero), the fixup operation will run any day. Fixup is run only when 5 or more consecutive compact operations fail (and the failure is not due to database in use). The value of d is between 0 and 7 where 1 is Sunday, 2 is Monday, and so on
Unfortunately, there is no UI in the admin client or domino directory to configure this. You have to create a program document, which starts the task on server startup.
This is really sad, I’m sure many customers will miss this great feature because of this…
Please IBM, just add a tab to the server or configuration document with all the possible options. This sounds not really complicated and would help to improve the usability.
There are some statistic values which can be used for monitoring:
DBMT.Compact.BackLog = 0
DBMT.Compact.Began = 01/02/2013 10:01:27 CET
DBMT.Compact.Finished = 01/02/2013 10:04:08 CET
DBMT.Compact.Fixup = 0
DBMT.Compact.Successful = 38
DBMT.Compact.Unsuccessful = 3
DBMT.Compact.Unsuccessful.InUse = 3
DBMT.Compact.Unsuccessful.TimeLimit = 0
DBMT.Updall.Began = 01/02/2013 10:01:27 CET
DBMT.Updall.Finished = 01/02/2013 10:04:11 CET
DBMT.Updall.Processed = 55
- New features and release notes
- IBM Notes/Domino 9.0 public beta download
- IBM Notes/Domino 9.0 public beta forum