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

Running the script to configure your DB2 for z/OS database for IBM Content Navigator

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

Before you begin

This task assumes that you:

About this task

You can run the script by using DB2 Connect™ from either the DB2 Control Center or the DB2 Command Window. However, if you want to run the script from the DB2 Control Center, you must modify the statement termination character. By default, the DB2 Control Center uses a semicolon (;) as the statement termination character. However, the DB2 for z/OS database script uses the plus sign (+) as the statement termination character. You can modify the statement termination character setting under Tools > Tool Settings.

Tip: If you prefer to update your database by running a JCL, you can copy the SQL statements from the updated DB2 for z/OS script to the JCL and submit it.
Ensure that you 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.

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

Procedure

To configure your DB2 for z/OS database for IBM Content Navigator:

  1. Log on to the server where DB2 Connect is located.
  2. Open one of the following tools:
    • DB2 Control Center and then open the Command Editor
    • DB2 Command Window
  3. 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
    1. Click Add and select the appropriate database instance.
    2. From the Target list, select the database instance.
    DB2 Command Window Enter db2 connect to database_name.
    Confirm that the task ran successfully.
  4. Run the script to create and populate the IBM Content Navigator configuration table:
    Interface Command
    DB2 Command Editor Open and run the DB2Z_ONE_SCRIPT.sql script.
    DB2 Command Window Enter db2 -nvf DB2Z_ONE_SCRIPT.sql" -td+.
    Confirm that the task ran successfully.

Results

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

What to do next

After you configure your database for IBM Content Navigator, you must:
  1. Restart the IBM Content Navigator web application server
  2. Verify your IBM Content Navigator deployment
  3. Configure the IBM Content Navigator web client
Parent topic: Running the script to configure your database for IBM Content Navigator