Creating the Db2 database

The second step in setting up DB2® for use with IBM® Product Master is to create a Db2 database.

About this task

It is assumed that you know how to create a Db2 database. For more information about how to create a Db2 instance, see the Db2 documentation or consult your DBA.

Procedure

Create the Db2 database. When you create the database, make sure to use CODESET UTF-8 option in the "CREATE DATABASE" statement.

Example

Sample statement for creating a database:

CREATE DATABASE PIMDB AUTOMATIC STORAGE YES ON '/u01/db2inst1',
 '/u02/db2inst1' USING CODESET UTF-8 TERRITORY US

In this example, PIMDB is the database name /u01/db2inst1 and /u02/db2inst1 are the automatic storage paths on the Db2 server, change the storage paths appropriate to your server. Change the territory from US to your appropriate territory. For more information, see the Db2 documentation for supported values for territory.