IBM 5.5 manual Creating the MySQL schema

Creating the MySQL schema

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>

Note: 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>

Chapter 2. Installing Netcool/Precision TN 27