Creating a Db2 for z/OS 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 for z/OS 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 for z/OS database before you create your database. Some of the values in the worksheet can be used to fill out the table in this topic.

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 for z/OS 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 schema	`@ECMClient_SCHEMA@`	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.
Database storage group	`@ECMClient_STOGROUP@`	The volumes where the IBM Content Navigator database table and indexes will be stored.
ICF catalog	`@ECMClient_VCAT@`	The integrated catalog facility (ICF) catalog that is associated with the storage group where you will create the IBM Content Navigator database table.
Database encoding scheme	`@ECMClient_CCSID@`	The encoding scheme that is used by the database manager to provide region-specific support. It is recommended that you use a Unicode CCSID to support localized character sets. For a list of Unicode CCSIDs, see Unicode in the Software for z/OS Solutions 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 for z/OS database for IBM Content Navigator:

Create and run an SQL script on your Db2 for z/OS 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 for z/OS database for IBM Content Navigator:

-- IBM CONTENT NAVIGATOR DB2 for z/OS SQL Script 
--
-- Tip: If you plan to create a database on a remote instance, 
-- remove the comment code from the following line:
-- ATTACH TO @ECMClient_NODENAME@+

SET CURRENT SQLID = '@ECMClient_SCHEMA@'+

CREATE STOGROUP @ECMClient_STOGROUP@ VOLUMES ('*') VCAT @ECMClient_VCAT@+
COMMIT+

CREATE DATABASE @ECMClient_DBNAME@ STOGROUP @ECMClient_STOGROUP@ CCSID @ECMClient_CCSID@+
COMMIT+