BESAdmin.info - Your Technical Support Source

Yahoo Buzz Technorati Stumbleupon Reddit Myspace Digg Delicious

Run Fixup, Updall, and Compact maintenance tasks for IBM Lotus Domino database


Doc ID: KB02207
Modified Date: 09-28-2009
Document Type: Support

Products

  • BlackBerry® Enterprise Server for IBM® Lotus® Domino®



Environment

  • BlackBerry® Enterprise Server for IBM® Lotus® Domino®



Overview

The BlackBerry Enterprise Server depends on existing databases, such as the mail files and the IBM® Lotus® Domino® directory, for its operation. Corruption of a database design, form, document, view, or index can cause a number of issues with the BlackBerry Enterprise Server. To help correct these problems, an administrator can run maintenance tasks, such as Fixup, Updall and Compact.

Some issues that the maintenance tasks may correct are the following:

  • Unable to add a BlackBerry smartphone user account to the BlackBerry Enterprise Server
  • Unable to scan a mail file
  • Cannot redirect messages to a BlackBerry smartphone
  • Unable to open a redirection folder
  • BlackBerry profiles database is not updated with BlackBerry smartphone user information when changes are made in Redirector Settings of BlackBerry® Desktop Manager, or when a new encryption key is generated
  • BlackBerry smartphone user name is not found in the IBM Lotus Domino directory
 
Procedure

The BlackBerry Enterprise Server creates IBM Lotus Domino-designed databases, such as BlackBerryProfiles.nsf, BlackBerryOutbox.nsf, BBDir.nsf, BBStats.nsf, and a uniquely named BlackBerry state database for each user.

Note: These maintenance task can be performed either online or offline, as desired. Refer to the appropriate procedure below.
 
Procedure for Offline Maintenance
 
Complete the following steps to perform IBM Lotus Domino offline maintenance tasks on specific databases:
 
  1. Stop the IBM Lotus Domino Server.
  2. Open a command prompt window.
  3. At the command prompt, browse to the IBM Lotus Domino directory and run the following command(s) on the problem database(s) in the following order:



    nfixup

    This corrects corrupted views and documents.

    nupdall -R

    This rebuilds all used views and fixes corrupted views and full-text indices. This task is resource-intensive.

    ncompact -c

    This can fix database corruption.

    Note: See the Additional Information section for examples of the command syntax.

  4. Start the IBM Lotus Domino Server.
Procedure for Online Maintenance
 
For online maintenance, the same set of Commands can be run, except the "n" in front of the command is dropped, and the command Load is needed. The command is run from the Domino console. Caution should be taken when running online maintenance as this can affect the performance of your server.
  1. Commands are run against the BlackBerry Enterprise Server folder located within C:LotusDominoData directory.
  2. Run the following command(s) on the problem database(s) in the following order:
    • The following corrects corrupted views and documents in databases that are unopen, skipping the open databases. Add the -o switch to take the databases offline and correct any corrupt views and documents:

       Load fixup BES

       
    • The following rebuilds all used views and fixes corrupted views and full-text indices. This task is resource-intensive.

       Load updall -R BES

    • The following can fix database corruption.

       Load compact -c BES

    Note: See the Additional Information section for examples of the command syntax.

     



Additional Information

At the command prompt, use the following syntaxes to issue the commands described in this document:
 
For offline maintenance:

n <task_name><database_file_name>

For online maintenance:
 
Load <task_name><database_file_name>
 
Some usage examples are the following:
  • ncompact -c BlackBerryOutbox.nsf
  • nfixup names.nsf
  • nupdall -R BESBlackBerryProfiles.nsf
  • Load fixup BESBlackBerryProfiles.nsf
  • Load Compact -c BESBlackBerryProfiles.nsf
  • Load Updall -R BESBlackBerryProfiles.nsf

When maintaining a template, specify the extension . ntf after the template name.

Refer to IBM Lotus Domino Administrator Help files for more information on troubleshooting databases.




The following are keyboard shortcuts you can use to update or rebuild views while the IBM Lotus Domino Server is running:

  • F9 to update the current view.
  • SHIFT + F9 to rebuild the current view.
  • CTRL + SHIFT + F9 to rebuild all views in the database that are not built and update all other views. This is similar to running Updall on a database.