Installation Guide for IBM DB2 with Red Hat JBoss

Back Next

Import the Metadata into the MDM Hub Master Database

After you create the

MDM Hub Master Database

, import the initial metadata into the

MDM Hub Master Database

. 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_system

On Windows.

sip_ant.bat import_system

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 database host name [localhost]	Name of the host that is running the database.
Enter the database port number [50000]	Port number that the database listener uses. Default is 50000 .
Enter the database instance name [SIP97]	Name of the database. Default is SIP97 .
Enter master database name [cmx_system]	Name of the MDM Hub Master Database schema. Default is cmx_system .
Enter master user name [cmx_system]	User name to access the MDM Hub Master Database. Default is cmx_system . On UNIX, ensure that you use a user name with 8 characters or less.
Enter master database user password	Password to access the MDM Hub Master Database.
Enter locale name from the list: de, en_US, fr, ja, ko, zh_CN. [en_US]	Operating system locale. Default is en_US .
Connect URL [jdbc:db2://localhost:50000/SIP97:currentSchema=CMX_SYSTEM;]	Connect URL for IBM DB2. Default is jdbc:db2://localhost:50000/SIP97:currentSchema=CMX_SYSTEM .