Configuring ping data

You can configure chassis ping polls to retrieve the timestamp of the first ping failure, when a Chassis Ping Fail alert is generated, after the configured number of retries are completed.

1. Back up and edit the $NCHOME/etc/precision/NcPollerSchema.cfg file.
2. To enable this feature, change 0 to 1 in the following section:

   update config.properties set
   AddFirstPingFailTimeStampInPingAlerts=1;

   The default setting of 0 disables the feature, and 1 enables it.

3. Run the following command to add the FirstPingFailTimeStamp field to the ObjectServer alerts.status table.

   $NCHOME/omnibus/bin/nco_sql -server ObjectServerName -user root -password PASSWORD -i /opt/IBM/tivoli/netcool/precision/scripts/add_first_pingfail_timestamp_column.sql

   Where:

   • ObjectServerName is the name of the ObjectServer, for example, NCO_AGG_P.
   • PASSWORD is the password for the root user.
4. Check that the new field FirstPingFailTimeStamp exists in the ObjectServer alerts.status table.
   1. Run the following command:

      $NCHOME/omnibus/bin/nco_sql -server ObjectServerName -user root -password PASSWORD

      Where:

      • ObjectServerName is the name of the ObjectServer, for example, NCO_AGG_P.
      • PASSWORD is the password for the root user.
      The command opens an SQL prompt.
   2. At the SQL prompt, run the following command and check that the new field is present in the output list of fields:

      describe alerts.status

5. Back up and edit the following file: $NCHOME/probes/linux2x86/nco_p_ncpmonitor.rules. Locate the following section:

   if ( exists($ExtraInfo_EVENTMAP) )
   {
       @NmosEventMap = $ExtraInfo_EVENTMAP
   }

   Add the following lines after the preceding section:

   if ( exists($ExtraInfo_FIRSTPINGFAILTIMESTAMP) )
   {
       if (match($EventName, "NmosPingFail"))
       {
          @FirstPingFailTimeStamp = $ExtraInfo_FIRSTPINGFAILTIMESTAMP
       }
   }