Problem using dbmt and indirect files

Hello

For the maintenance of system databases we still use compact and want to change to dbmt. We tried "dbmt -compactThreads 4 -updallThreads 0 systemdbs.ind". Where systemdbs.ind is the same indirect file that was used by compact.

As a result dbmt runs for a few seconds and terminates. The "compact date" of the system databases do not change.

Below is the output in log.nsf.

01.12.2024 23:15:36 Server shutdown complete

01.12.2024 23:15:50 Recovery Manager: Restart Recovery complete. (0/0 databases needed full/partial recovery)
01.12.2024 23:15:50 DBMT: Database Maintenance started: -compactThreads 4 -updallThreads 0 systemdbs.ind
01.12.2024 23:15:53 Database compactor process shutdown

What must be done to maintain system databases with dbmt?

Thank you!

Regards

Patrice

What version of Domino are you using?
I assume you are using a program document, what is the schedule?
Are you getting the same result when running it manually?

systemdbs.ind should not be used with dbmt: you should use it in another program document with a a compact -B because system databases are skipped by dbmt

Hi,

DBMT always excludes the system databases from compacting. Here is the list of databases that exclude -> https://help.hcl-software.com/domino/14.0.0/admin/admn_maintaining_user_mail_files_using_the_dbmt_tool_t.html

You may use a separate program document \ or script \ or .ind file to run the compact on the system databases.

Thanks

Hello and thank you for your answers!

This means that there is no way to use dbmt for system databases and they must be maintained with compact. Is this correct?

Regards

Patrice

Hi Patrice,

In case you are running Domino v12 or later, you might be hitting this issue documented below:

https://support.hcl-software.com/csm?id=kb_article&sysparm_article=KB0116363

Hi Joanne

Domino is at V12 and this article describes the problem exactly: "DBMT should not skip the system databases if their filenames are listed in the IND file."

Thank you!

Regards

Patrice

Hi Patrice,

As others have mentioned, since R12, the DBMT compact thread no longer processes system databases from an IND file.

The good news is that compact has no issue with it (but you probably know that).

With our Optimizer product, you can schedule a load compact OPTIMIZER_Sys_Databases.ind -REPLICA -REN_WAIT 5 -RESTART through the UI and it works like a treat

Shameless plug, check it out if you have time.

Hello

Defect article KB0116363 says “The DBMT task should not skip the system databases if their filenames are listed in the IND file.” The status is “resolved” and “Fixed in build(s) 12.0.2 FP3 and 14.0 FP3 and 14.5”.

We are at Release 12.0.2FP5HF8 and still cannot use dbmt for system databases (see my first post for details).

I wanted to know what is the recommended method for maintaining system databases and if this issue (SPR JLUSD99K7A) is resolved.

Thank you!

Regards

Patrice

Hello Patrice,

Could you try upgrading the Domino to 1202FP6 or a later version and see if the problem persists?

Thanks

Hello Sooraj

Unfortunately I’m not allowed to do any software maintenance during 4th quarter of this year. Is there a chance that the issue is resolved in FP6+? We still use offline compact -c for system databases. Is dbmt the recommended method also for them?

Thank you!

Hello Patrice,
It appears that this issue has been resolved in versions 1202FP6 and above.
You can certainly use dbmt. In case you need basic maintenance commands, have a look at these documents:Administrator Guide for Domino Server maintenance - Customer Support & Domino Server Offline Maintenance for different platforms - Customer Support

Thanks