IBM 5.5 ユーザーズマニュアル

To create the MySQL database schema, you must first run the ncim.sql and 
leap_schema.sql

 scripts located in the 

<netcool_install_dir>/etc/precisiontn/sql/mysql

 directory. 

To create the schema:

1.

Ensure that you have followed the steps in "Configuring Netcool/Precision TN" on 
page 26. 

2.

You must log in as an appropriate user with the permissions needed to create new 
tables in the database. See your MySQL documentation for MySQL user information. 

Run MySQL to load the schema by entering: 

cat <netcool_install_dir>/etc/precisiontn/sql/mysql/ncim.sql | mysql 

--user=<username> --password=<password> <databasename>

cat <netcool_install_dir>/etc/precisiontn/sql/mysql/leap_schema.sql | 

mysql --user=<username> --password=<password> <databasename>

If you are already running Netcool/Precision TN with Netcool/Precision IP or 
Netcool for Asset Management which are already using the NCIM schema, do 
not execute the ncim.sql file.

3.

If the tables have been successfully created in the MySQL database, you will see 
output similar to:

SQL> @<netcool_install_dir>/etc/precisiontn/sql/mysql/

leap_schema.sql;

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Table created.

Commit complete.

SQL>