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

Worksheet for creating a data source and updating the database script for your DB2 pureScale database

Work with your database administrator to gather the information that you need to connect to your DB2® pureScale® database, create a data source for your IBM® Content Navigator database on the web application server and update the script that is used to create a table for IBM Content Navigator on your database. The data source enables the web client to connect to the IBM Content Navigator database. The IBM Content Navigator Configuration and Deployment Tool requires that you enter values that are prepared in advance. The worksheet is a useful place to put these values.

Print this worksheet and enter values as you prepare for your installation.

Use this worksheet when you do the following configuration and deployment tasks in the IBM Content Navigator Configuration and Deployment Tool:

Update and Run the Database Script for Your Environment
Creating a Data Source for Your Database

Table 1. Parameters required by the IBM Content Navigator Configuration and Deployment Tool to create a data source for your DB2 pureScale database
Parameter	Description	Value
JDBC driver	The JDBC driver that corresponds to the type of database where you will store IBM Content Navigator configuration data. IBM Content Navigator supports the following JDBC drivers: DB2 Universal JDBC Driver DB2 for z/OS® Universal JDBC Driver (available on WebSphere® Application Server only) DB2 Universal JDBC Driver (pureScale or HADR) (available on WebSphere Application Server only) Microsoft JDBC Driver Oracle JDBC Driver Oracle JDBC Driver (RAC Support) Remember: You must copy the JDBC driver for your database to the IBM Content Navigator server. In addition, if you are deploying on Oracle WebLogic Server, you must add the JDBC driver class path to the Oracle WebLogic Server startup script. For more information, see Preparing Oracle WebLogic Server for IBM Content Navigator.	DB2 Universal JDBC Driver (pureScale of HADR)
JDBC driver version	The version of the JDBC driver that is installed on the IBM Content Navigator database server.
Database version	The version of the database that is installed on the IBM Content Navigator database server.
JDBC data source name	The name of the non-XA JDBC data source that you want to create to communicate with the IBM Content Navigator database. The name must be unique and cannot contain spaces. The default name is ECMClientDS. You cannot run this task if the data source name exists on your web application server. It is recommended that you remove the existing data source by using your application server administration tools before you run this task.
Database host name	The short name, long name, or the IP address of the server where the IBM Content Navigator database software is installed.
Database port	The port number that is used by the database instance where you want to create the IBM Content Navigator configuration table. The default port is 50000.
Database name	The name of the database that you created to store the IBM Content Navigator configuration data and user preferences. This is the database where you want to create the IBM Content Navigator configuration table. You must specify an existing database.
Database user name	The name of the database user that theIBM Content Navigator data source will use to connect to the database. The user must have INSERT, DELETE, and SELECT authority on the IBM Content Navigator configuration table.
Database user password	The password of the specified database user.
Retry interval for client reroute	The time (in seconds) between connection attempts made by the automatic client reroute if the primary connection to the server fails.
Maximum retries for client reroute	The maximum number of connection attempts made by the automatic client reroute if the primary connection to the server fails.
Alternate server name and port number	The list of alternate server names and port numbers for the DB2 server. Separate the server name and port number with a colon (:). Separate each server entry with a comma (,). For example, enter: host_name1:port_1,host_name2:port_2.
IBM Content Navigator administrator	The name of the user that you want to use as the IBM Content Navigator administrator. Important: This user must be an existing web application server user name or LDAP user name. This parameter is the ECMClient_ADMINID parameter in the database script, DB2_ONE_SCRIPT.sql.
IBM Content Navigator schema name	The name that you want to use for the schema when you create the IBM Content Navigator database table. See your database documentation for naming restrictions. This parameter is the ECMClient_SCHEMA parameter in the database script, DB2_ONE_SCRIPT.sql.
Table space name	The name of the table space that you want to create on the IBM Content Navigator configuration database. This parameter is the ECMClient_TBLSPACE parameter in the database script, DB2_ONE_SCRIPT.sql.
JDBC directory	The directory where you installed the JDBC driver files on your IBM Content Navigator server. If you plan to deploy IBM Content Navigator in a highly available cluster, you must copy the driver files to the same directory on each node in the cluster.
JDBC configuration script	The fully qualified path of the JDBC data source configuration script. The name of the script depends on the web application server you are using: On Oracle WebLogic Server, the script is configureWLJDBC.py. On WebSphere Application Server, the script is configureWSJDBC.tcl. On AIX®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Linux, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Linux for System z®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Windows, the default directory is C:\Program Files (x86)\IBM\ECMClient\configure\scripts\`script_name`.
Current database configuration	Specify whether your database has already been configured for IBM Content Navigator or not.
Run the script on your database	You can use the IBM Content Navigator Configuration and Deployment Tool to run the script that is generated by this task on your database server. When you run this script, it creates the objects that you identified in this task on the database and populates the database with the default configuration. If you do not select this option, you must manually run the updated script on your database server to create the IBM Content Navigator configuration table on your database instance. You must complete this step after you deploy the web application but before you administer the web client. Specify whether this option applies to your environment.
Enable database connection validation	You can enable connection validation (WebSphere Application Server) or automatic connection testing (Oracle WebLogic Server) on the data source to decrease the likelihood of the web client encountering a connection failure to the database. For more information on connection validation and automatic connection testing, see your web application server documentation. Specify whether this option applies to your environment. Note: This description is different from the description in the IBM Content Navigator Configuration and Deployment Tool. Refer to this description when completing the task.