Moving views out of databases

You can move views out of Notes databases into separate view index files (.NDX files).

Before you begin

To use this feature, databases must be at ODS version 51 or higher. For information about ODS and controlling ODS version, see Domino on-disk structure (ODS).

About this task

This feature is useful for large databases and provides the following benefits:
  • A smaller database file size, to avoid reaching the 64GB limitation.
  • Faster database backup and restore.
.NDX files have a limit of 1 TB. The real determination of how large the views can grow is based on application responsiveness or if any other limits are reached before the 1 TB .NDX file limit is reached.

Procedure

  1. Enable transactional logging in the Server document in the Domino directory.
  2. Add the following notes.ini setting on the Domino server, then restart the server:
    NIFNSFEnable=1
  3. Optional: The .NDX files are stored in the Domino data directory, by default. To specify a different location, add the following notes.ini setting:
    NIFBasePath=path

    where path is an explicit or relative path. A relative path, for example, NIF, is relative to the Domino data directory. If the location is on a different computer, map the location to the local computer.

  4. Enable the feature on specific databases:

    To enable separate view indexes on an existing database, run the following compact command on the server:

    load compact -c -nifnsf on xxxxx.nsf 

    To enable separate view indexes on all databases created in the future, add the following notes.ini setting:

    CREATE_NIFNSF_DATABASES=1
  5. Restart the server.

What to do next

Use the following server console command to show all databases, whether they use separate view indexes (NIFNSF state ON), and if so the .NDX file size:

show dir -nifnsf
Use the following server console command to show only information about databases that use separate view indexes:

show dir -nifnsfonly

To disable separate view indexes on an database that currently uses them, run the following compact command on the server:

load compact -c -nifnsf off xxxxx.nsf