A Lotus Technical Blog by the MartinScott Team

MSG - the MartinScott Guide to all things Collaboration

DB HealthCheck finds common problems with AdminP, NAMES.NSF

Daryl Rochette  January 17 2010 05:47:36 AM
Many types of issues can prevent proper functionality of system databases such as admin4.nsf and names.nsf.  This free utility will perform a health check on any database, looking for consistency between copies across servers, including: replication, administration, design, data, and security properties.  This can save you hours of time trying to figure out why your AdminP requests aren't processing across servers, or why your Directory isn't behaving.  This is only a 1.00 version, so comments and suggestions are welcome!

Image:DB HealthCheck finds common problems with AdminP, NAMES.NSF
HealthCheck.nsf
 
Comments

1Werner Motzet  01/17/2010 8:21:22 AM  DB HealthCheck finds common problems with AdminP, NAMES.NSF

Hello Martin,

very good job, I did a first test today, but will do more tests next week, as I have some "Special Candidates" to do this Check and will give you a feedback.

Thank you very much.

Kind Regards Werner

2Leif Lagebrand  01/17/2010 10:39:45 AM  DB HealthCheck finds common problems with AdminP, NAMES.NSF

Very nice!

Next maybe would be to act on things, for example to set the ACL the same as the master database.

3Jamie Magee  01/17/2010 1:13:44 PM  DB HealthCheck finds common problems with AdminP, NAMES.NSF

Thanks, Werner and Leif! Yes, we do plan to evolve this further including ability to set replica id, ACL, and other "fix" actions.

PS Werner, we received your other suggestion and already have uploaded a new version. Thank you very much for that.

4Ulrich Krause  01/18/2010 1:11:25 AM  DB HealthCheck finds common problems with AdminP, NAMES.NSF

Good job.

I would appreciate this to be open source.

I simply wanted to extend the "on these servers" field to servers not in the primary address book but keeping replicas of databases to be checked.

A suggestion: If there are differences in documents, list the differences. Not in detail; I'm only thinking of the number of differences for a form. ( db A has more person records than db B )

5Steve Cannon  01/18/2010 10:16:32 AM  DB HealthCheck finds common problems with AdminP, NAMES.NSF

Will there be a release without a hidden design?

6Jamie Magee  01/19/2010 8:45:58 AM  DB HealthCheck finds common problems with AdminP, NAMES.NSF

Yes, there will be an open source version shortly. In this build, we had to use the ACL compare code from NoteMan, but we'll clean that code for an open source version. And we'll also allow more server name choice options. Thank you for the feedback!