Installation Guide for IBM DB2 with Red Hat JBoss

Back Next

Import the Metadata into the Operational Reference Store

After you create the

Operational Reference Store

, import the initial metadata into the

Operational Reference Store

. The initial metadata includes repository tables and other objects that the

MDM Hub

requires in the

Hub Store

If you change the folder names in the distribution directory, metadata import fails.

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

MDM Hub distribution directory

>/database/bin

To import the initial metadata, run the following command:

On UNIX.

./sip_ant.sh import_ors

On Windows.

sip_ant.bat import_ors

Answer the prompts described in the following table:

The prompts display default text in brackets. Press

Enter

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

Prompts	Description
Enter the database type (ORACLE, MSSQL, DB2)	Database type. Specify DB2 .
Enter the Operational Reference Store database host name [localhost]	Name of the host that is running the database.
Enter the Operational Reference Store database port number [50000]	Port number that the database listener uses. Default is 50000 .
Enter the database name [SIP97]	Name of the database. Default is SIP97 .
Enter the Operational Reference Store database name [cmx_ors]	Name of the Operational Reference Store database. Default is cmx_ors .
Connect URL. [jdbc:db2://<host name>:<port>/<database name>]	Connect URL for the master database. Default is jdbc:db2://<host name>:<port>/<database name> .
Enter the Operational Reference Store database user name [cmx_ors]	User name to access the Operational Reference Store. Default is cmx_ors .
Enter the Operational Reference Store database user password	Password to access the Operational Reference Store.
Enter locale name from the list: de, en_US, fr, ja, ko, zh_CN. [en_US]	Operating system locale. Default is en_US .
Enter the integer code of Operational Reference Store Timeline Granularity: Year 5, Month 4, Day 3, Hour 2, Minute 1, Second 0 [3]	Specify timeline units to use. Default is days. The timeline granularity that you configure cannot be modified later. For more information about timeline, see the Multidomain MDM Configuration Guide .