Creating a Db2 database for IBM Content Navigator

You must point to an existing UTF-8 database when you configure and deploy IBM Content Navigator. You can reuse an existing UTF-8 database or you can create a Db2 database where you can create the IBM Content Navigator configuration table after you configure and deploy the web application.

Before you begin

It is recommended that you complete the Worksheet for creating a data source and updating the database script for your Db2 database before you create your database. Some of the values in the worksheet can be used to fill out the table in this topic.

This prerequisite task applies for traditional application server deployments only. For container deployments, the worksheet preparation steps do not apply.

About this task

You can modify the sample code that is provided in this task for your environment. However, at a minimum, you must provide values for the parameters that are specified in the sample code.

At a minimum, you must specify:

Table 1. Minimum requirements for creating a Db2 database for IBM Content Navigator
Worksheet parameter	Sample code variable to replace	Description
Database name	`@ECMClient_DBNAME@`	The name of the database where you will create the IBM Content Navigator configuration table. See your database documentation for naming restrictions.
Database drive	`@ECMClient_DBDRIVE@`	The local drive or file system where you want to create the database, for example: `C:` On Windows `/db2data` on AIX®, Linux®, and Linux for System z®
Database territory	`@ECMClient_TERRITORY@`	The territory code that is used by the database manager to provide region-specific support. It is recommended that you use UTF-8 encoding to support localized character sets. For a list of territory codes, see Supported territory codes and code pages in the Db2 Database for Linux, UNIX, and Windows Information Center.
Database node	`@ECMClient_NODENAME@`	The cataloged node name of the remote instance. Specify this value only if you want to create a database on a remote instance.

This task assumes that you are logged in to your database server with the appropriate permissions required to create a database on that server.

Procedure

To create a Db2 database for IBM Content Navigator:

Create and run an SQL script on your Db2 instance.

You can use the following sample code to create a simple database.

Remember: You must replace the variables in the sample code with the appropriate values for your environment.

Example

Sample code for creating a Db2 database for IBM Content Navigator:

-- IBM CONTENT NAVIGATOR DB2 SQL Script 
--
-- Tip: If you plan to create a database on a remote instance, 
-- ensure that the @ECMClient_NODENAME@ node has been
-- cataloged and remove the comment code from the following line:
-- ATTACH TO @ECMClient_NODENAME@;

CREATE database @ECMClient_DBNAME@ AUTOMATIC STORAGE YES ON 
@ECMClient_DBDRIVE@ DBPATH on @ECMClient_DBDRIVE@ 
USING CODESET UTF-8 TERRITORY @ECMClient_TERRITORY@ COLLATE USING SYSTEM;