Installation Guide for IBM DB2 with Red Hat JBoss

10.3 HotFix 2

Back Next

Use a Script to Create a Database and Tablespaces

The MDM Hub distribution includes a script to create the database and associated tablespaces. To run the script, you need administrative privileges with write and execute permissions to the DB2 data directory.

On UNIX, before you create the database, update the

db2.storage.path

property in the

database.properties

file with the correct database storage path. The

database.properties

file is in the following directory:

MDM Hub distribution directory

>/database/bin/db2

Open a command prompt, and change to the following directory:

MDM Hub distribution directory

>/database/bin

To create the database, run the following command:

On UNIX.

./sip_ant.sh create_db

On Windows.

sip_ant.bat create_db

Answer the prompts described in the following table:

Prompt	Description
Enter the database type (ORACLE, MSSQL, DB2)	Database type. Specify DB2.
Enter the database instance name [db2]	Name of the database instance. Default is db2 .
Enter the database name [SIP97]	Name of the database. Default is SIP97 .
Enter the database storage path [C:\DB2DATA]	Path to the directory where the database must be stored. Default is C:\DB2DATA . On UNIX, accept the default value. The database storage path that you specify in the database.properties file will be used.
Enter the DBA user name [DB2ADMIN]	User name of the administrative user. Default is DB2ADMIN .
Enter the DBA password	Password of the administrative user.