IBM Notes/Domino 9.0: Database Maintenance Tool (DBMT)

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.

Some examples:
-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.

dbmt

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

Links:

Advertisements
This entry was posted in IBM Notes/Domino and tagged , , , , , , . Bookmark the permalink.

8 Responses to IBM Notes/Domino 9.0: Database Maintenance Tool (DBMT)

  1. John Head says:

    link this in the public beta or (if you have access) the DP forum. Otherwise they won’t see this.

  2. Pingback: My favorite IBM Notes/Domino 9.0 features | StephanKopp.net

  3. Ah, kind of like this already. Thanks for posting. And I agree, there should be a better way of handling this than program docs.

  4. Pretty nice post. We located your blog – and wanted to express that I’ve really enjoyed browsing your website post posts. In the end I’ll be signing
    up your feed we we imagine you write again very soon!

  5. marlot says:

    Impossible for me to use DBMT_FILTER. Dont’ seems to work in R9 !
    I try DBMT_COMPACT_FILTER too

Comments are closed.