IBM Content Navigator, Version 2.0.3 Supports: Content Manager, FileNet P8, OnDemand, OASIS CMIS

Running the script to update your DB2 database for IBM Content Navigator

You must configure your DB2® database to create a table where you can store IBM® Content Navigator configuration data and preferences.

Before you begin

This task assumes that you:

Ran the IBM Content Navigator Configuration and Deployment Tool to update the table creation script for your environment.
Remember: You must run this script on the database where you created the database user that you specified when you ran the IBM Content Navigator Configuration and Deployment Tool.
Copied the updated script to your database server or made the script available to your database server from a shared network drive. For more information, see Running the script to configure your database for IBM Content Navigator.

You can run the script from either the DB2 Control Center or the DB2 Command Window.

Ensure that you run the appropriate version of the script for your environment:

If you are running DB2 Version 9.5 or earlier, run the file in the db2_9.5 directory.
If you are running DB2 Version 9.7 or later, run the file in the db2 directory.

You must connect to the database instance as a user with administrative authority to run the script.

To configure your DB2 database for IBM Content Navigator:

Log on to the server where DB2 is located.
Open one of the following tools:
- DB2 Control Center and then open the Command Editor
- DB2 Command Window

Connect to the database instance where you plan to store IBM Content Navigator configuration data as a user with administrative authority:

Interface	Command
DB2 Command Editor	Click Add and select the appropriate database instance. From the Target list, select the database instance.
DB2 Command Window	Enter `db2 connect to database_name`.

Confirm that the task ran successfully.

Interface	Command
DB2 Command Editor	Open and run the DB2_ONE_SCRIPT.sql script.
DB2 Command Window	Enter `db2 -tvf DB2_ONE_SCRIPT.sql`.

After you run the script, the IBM Content Navigator table should be created and populated on your database.

After you configure your database for IBM Content Navigator, you must: