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

This section describes the configuration tasks you must complete for Netcool/OMNIbus 
ObjectServer version 3.6. See "Configuring the Netcool/OMNIbus ObjectServer versions 
7.0 and 7.1" on page 37 for instructions on configuring versions 7.0 and 7.1.

To configure Netcool/OMNIbus, you must edit the ObjectServer SQL file and migrate the 
data within it. 

The default ObjectServer name is NCOMS and the SQL file is NCOMS.sql. In this 
chapter references to this file will be shown as ObjectServername.sql. Replace 
ObjectServername

 with the name you gave to your own Netcool/OMNIbus 

ObjectServer.

To visualize alerts in Netcool/OMNIbus, you must add new elements to the ObjectServer 
alerts.status

 table in the ObjectServername.sql file that was installed as part of 

Netcool/OMNIbus. You must add the following columns to the end of the 
alerts.status

 table:

PtnEntityID varchar(255),

PtnNative1 varchar(255),

NmosDomainName varchar(255),

To add the columns to the alerts.status table:

1.

Check that the ObjectServer is not running. See the Netcool

Guide if you need instructions on how to stop the server.

2.

Back up all of the Netcool/OMNIbus database files by creating a tmp directory and 
copying the database files to the tmp directory. The database files are typically located 
in $OMNIHOME/db.

3.

Change directory to $OMNIHOME/etc.

4.

Copy ObjectServername.sql and rename it ObjectServername.orig. 

You must use the .orig suffix when you rename this file. The nco_migrate 
migration tool looks for a file with this extension.

5.

Open ObjectServername.sql file with a text editor. 

6.

Edit the definition within the parentheses that start after this line:

create table status 

Paste the columns (shown below in bold) into the file, before this line:

primary key ( Identifier ),

After you paste in the columns, the relevant part of the file should look similar to this: 

create database alerts;

use database alerts;