Creating a IBM Db2 pureScale or HADR 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 IBM Db2 pureScale or high availability disaster recovery (HADR) 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 pureScale database before you create your database. Some of the values in the worksheet can be used to fill out the table in this topic.

Note: The reads on standby feature is not supported on IBM Db2 pureScale databases with HADR enabled. For more information, see https://www.ibm.com/support/pages/node/7184193 External link opens a new window or tab

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 IBM Db2 pureScale 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@`	A cataloged node name of a 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 IBM Db2 pureScale database for IBM Content Navigator:

Create and run an SQL script on your IBM Db2 pureScale 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;