Manage Learn to apply best practices and optimize your operations.

Repair local databases on desktop

This tip explains how to use nfixup and ncompact to repair local DBs on a desktop such as PAB and a local archive.

View member feedback to this tip.

Local databases on the user's desktop such as personal address book and local archive sometimes become corrupted and require repair.

There are "command prompt" versions of the server database maintenance utilities (Fixup, Updall and Compact) available to repair local databases.

The local tools are nfixup.exe, nupdall.exe and ncompact.exe. The Notes desktop client install includes nupdall.exe but not the other two. Nfixup and ncompact are found in the Domino folder on the server. They fit on a floppy disk and may be copied into the user's LotusNotes folder to run at the desktop.

Here's how:

  1. Close all running applications, including Notes.
  2. Go to Command prompt in folder LotusNotes> (this is your "live console" on the local PC).
  3. At the Command prompt LotusNotes>, enter these commands and switches in the following order:
    1. (Enter the user's Notes password when prompted)
    2. nfixup c:lotusnotesdata(filename)
    3. nupdall -r c:lotusnotesdata(filename)
    4. ncompact c:lotusnotesdata(filename)
  4. Do not start the next command until you see that the previous command has shut down. Type Exit to return to Windows.


The nupdall command syntax should be "nupdall c:lotusnotesdata(filename) -R" and not "nupdall -r c:lotusnotesdata(filename)." The -R should be at the end, otherwise it will run on all databases instead of just the specified one.

—Ninad L.

Do you have comments on this tip? Let us know.

This tip was submitted to the tip exchange by member Karen Shumaker. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Dig Deeper on Lotus Notes Domino Database Management



  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...