Step 9: Adding columns to the ObjectServer

Use this step to add columns to the ObjectServer AGG_P.

Proceed as follows:

  1. On the targethost computer, stop the probe, using the command:

    $NCHOME/omnibus/bin/nco_pa_stop -server NCOPR_PA -service Probes

  2. Using Netcool/OMNIbus Administrator or nco_sql, add the following fields to the alerts.status table:
    CustomerID int,
CustomerContact varchar(1024),
ReferenceCode varchar(128),

    If you use nco_sql to add the fields, use the ALTER TABLE command.

  3. On the targethost computer, restart the probe, using the command:

    $NCHOME/omnibus/bin/nco_pa_start -server NCOPR_PA -service Probes

    The probe uses a recovery file that records the last log file entry it read. It reads this and then reads the /var/log/ncolog file from the next entry.

  4. Check that the probe is running correctly under process control, using the command:

    $NCHOME/omnibus/bin/nco_pa_status -server NCOPR_PA -user netcool

  5. Check that the Syslog probe is reading messages from the /var/log/ncolog file, using the command:

    logger -p debug "testing the new tables"

  6. Restart the event list on the Windows computer ncdesktop and log on to AGG_P. The event list will contain an event with the summary testing the new tables.

The configuration of the Tivoli Netcool/OMNIbus basic architecture is complete.