Planning for your configuration database

IBM Content Navigator stores configuration data and preferences in a database. You can use an existing database or create a database for the IBM Content Navigator data. However, you must create the database before you install and configure IBM Content Navigator.

If you choose to create a database for IBM Content Navigator, see Creating a database for IBM Content Navigator.

If you choose to reuse an existing database, it is recommended that you:
  • Create a separate schema for IBM Content Navigator to use
  • Create a separate user for IBM Content Navigator to use
Oracle Database only: A schema is equivalent to a user. Creating a new schema will result in a new user being created.
Restriction: Keep in mind the following restrictions when you plan for your configuration database:
  • IBM FileNet P8 users only.Do not use the global configuration database to store IBM Content Navigator data.
  • If you plan to use IBM Content Navigator to connect to multiple types of repositories, such as IBM Content Manager and IBM Content Manager OnDemand, do not use a database that is used by either repository. If either repository is down for backups, upgrades, and so on, it can affect the users of the other repository.

You can use any of the supported database types for your IBM Content Navigator configuration database, regardless of the type of database that your content repository uses. However, you can reuse your content repository database to store your IBM Content Navigator configuration data.

The following information is stored in the IBM Content Navigator configuration database:
  • The 10 most recent saved searches for each user
  • Each user’s favorites

Work with the database administrator to collect the information that is listed in the database worksheet for your database server type. Enter the values into the worksheet so that you can easily provide that information when required.

Capacity planning for the configuration database

For each desktop that a user has, one row in the table is used, with a maximum of 32 KB per row. A general rule for initially sizing the database is 32 KB multiplied by the number of users, which is multiplied by the average number of desktops that each user will use.

User accounts for the configuration database

To create the IBM Content Navigator configuration table on the database that you create, you must have user accounts with specific privileges. In addition, you might need additional privileges if you plan to run the script to build and configure your database from the IBM Content Navigator Configuration and Deployment Tool.

For more information, see Database accounts.