Installation Guide for IBM DB2 with Red Hat JBoss

10.3 HotFix 1

Back Next

Step 4. Create the ActiveVOS Schema

To install ActiveVOS, you need to create the ActiveVOS schema. To create the schema, run the

create_bpm

script.

If you want to create multiple MDM Hub Master Databases, create an ActiveVOS schema for each MDM Hub Master Database.

Open a command prompt and change to the following directory:

MDM Hub distribution directory

>/database/bin

Run the following command:

On UNIX.

./sip_ant.sh create_bpm

On Windows.

sip_ant.bat create_bpm

Answer the prompts that appear.

The prompt displays default text in brackets. Press

Enter

to use the default value and go to the next prompt.

IBM DB2 data sources are case-sensitive. To avoid issues related to case-sensitivity, Informatica recommends that you use uppercase letters to define names, such as those for schemas, columns, and triggers.

Property	Description
Database Type	Type of database to use. For IBM DB2, specify DB2 . The database type must be the same as the database type selected for the MDM Hub Master Database and the Operational Reference Stores.
ActiveVOS Database Host Name	Name of the machine that hosts the database.
ActiveVOS Database TCP/IP Port	Port number that the database listener uses.
ActiveVOS Database Name	Name of the database.
ActiveVOS Database Schema/User Name	User name of the ActiveVOS Server administrative user.
ActiveVOS User Password	Password of the administrative user.
DBA User Name	User name of the database administrative user.
DBA Password	Password of the administrative user.
ActiveVOS Tablespace Name	The name of the tablespace that contains the records that are involved in MDM workflows.