Filter
Top Products
Chapter 2. Installing Netcool/Precision TN 27
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>