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

Updating your IBM Content Navigator database

After you upgrade your IBM® Content Navigator deployment, you must update your IBM Content Navigator database. You must complete this task only if you did not update the database script from the IBM Content Navigator Configuration and Deployment Tool.

Before you begin

Before you update your IBM Content Navigator database, you must make the updated script available to your database server. You can make the scripts available by:

Copying the script to your database server
Making the script available to your database server from a shared network drive

By default, the updated script is in the \configure\dbscripts subdirectory of the IBM Content Navigator installation directory.

Table 1. Default location of the updated database script
Operating system	Default location
AIX®	/opt/IBM/ECMClient/configure/dbscripts
Linux	/opt/IBM/ECMClient/configure/dbscripts
Linux for System z®	/opt/IBM/ECMClient/configure/dbscripts
Windows	C:\Program Files (x86)\IBM\ECMClient\configure\dbscripts

The updated script for each type of database is in the following subdirectory of the dbscripts directory: \database_type\modified. Use the modified files for your database type, for example, use the script in the \db2\modified directory if your database is a DB2® for Linux, UNIX and Windows database.

Important: Do not use the scripts in the database subdirectories (db2, db2zos, oracle, and sql). The scripts in the database subdirectories do not include the information that you specified in the IBM Content Navigator Configuration and Deployment Tool.

Procedure

To update your database for IBM Content Navigator, Version 2.0.3:

Run the appropriate script for your database:

Database	Procedure
DB2	Run the DB2_UPGRADE_SCRIPT.sql script on your IBM Content Navigator database by following the instructions in Running the script to update your DB2 database for IBM Content Navigator. 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. Be sure to run the DB2_UPGRADE_SCRIPT.sql script rather than the DB2_ONE_SCRIPT.sql script.
DB2 for z/OS®	Run the DB2Z_UPGRADE_SCRIPT.sql script on your IBM Content Navigator database by following the instructions in Running the script to configure your DB2 for z/OS database for IBM Content Navigator. Run the appropriate version of the script for your environment: If you are running DB2 for z/OS Version 9 or earlier, run the file in the db2zos_9 directory. If you are running DB2 for z/OS Version 10 or later, run the file in the db2zos directory. Be sure to run the DB2Z_UPGRADE_SCRIPT.sql script rather than the DB2Z_ONE_SCRIPT.sql script.
Microsoft SQL Server	Run the MSSQL_UPGRADE_SCRIPT.sql script on your IBM Content Navigator database by following the instructions in Running the script to configure your Microsoft SQL database for IBM Content Navigator. Be sure to run the MSSQL_UPGRADE_SCRIPT.sql script rather than the MSSQL_ONE_SCRIPT.sql script.
Oracle	Run the ORACLE_UPGRADE_SCRIPT.sql script on your IBM Content Navigator database by following the instructions in Running the script to configure your Oracle database for IBM Content Navigator Be sure to run the ORACLE_UPGRADE_SCRIPT.sql script rather than the ORACLE_ONE_SCRIPT.sql script.