IV19728: POLLER STORING TOO MANY ROWS IN NCPOLLDATA FOR PINGS

ITNMIP_Patch_V3.8.0.89_Win32
3.8.0-TIV-ITNMIP-Solaris-REF-FP0007
3.8.0-TIV-ITNMIP-Linux-REF-FP0007
ITNMIP_Patch_V3.8.0.89_AIXPPC32

APAR status

• Closed as program error.

Error description

• v3.8.0.75 - platform independent.
  
  Poller stores two rows for a given polled instance (e.g. ICMP).
  This request is to reduce number of rows to be one(1) - so that
  we store both polled time and response time under single row.
  The change will decrease number of rows we store in NCPOLLDATA
  and at the same time reduces overhead on Poller.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All ITNM 3.8 users.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Poller now stores two records of data for each ping poll.    *
  * The first record is the ping status (success or fail), the   *
  * second is the ping round trip time (RTT).  The second metric *
  * was added in a fix pack and the user was not given an option *
  * to disable it.  This caused for unwanted data being stored   *
  * in the customer's database.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * | fix pack | 3.8.0-ITNMIP-FP0007                             *
  ****************************************************************
  

Problem conclusion

• A new configuration field has been added to Poller that will
  disable the storing of the RTT values.  This field is a global
  setting and is set in the NcPollerSchema.cfg file.
  
  The instructions for setting are:
  
  Edit the file $NCHOME/etc/precision/NcPollerSchema.<domain>.cfg
  to set the ResponseTime property to
     disable storing the ping response time and restart poller.
  NOTE: the new ResponseTime column should be added at the bottom
     in the create table command.
  
   CREATE TABLE config.properties
   (
       PolicyUpdateInterval            int,
       ManagedStatusUpdateInterval     int,
       LogAccessCredentials            int type boolean,
       UseGetBulk                      int type boolean,
       DefaultGetBulkMaxReps           int,
       CheckPollDataValueRange         int type boolean,
       ResponseTime                    int type boolean
   );
  
   insert into config.properties
   (
       PolicyUpdateInterval,
       ManagedStatusUpdateInterval,
       LogAccessCredentials,
       UseGetBulk,
       DefaultGetBulkMaxReps,
       CheckPollDataValueRange,
       ResponseTime
   )
   values
   (
       30,     // ncp_poller will scan the NCMONITOR policy table
  every 30 seconds
        // for changes to polling configuration.
       .
       .
       .
       .
       0       // 0: don't store ping response 1: store ping
  response (default)
   );
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  NC/PRECISIONIP

• Fixed component ID

  5724O52RC

Applicable component levels

• R380 PSN

     UP

• R380 PSY

     UP

• R390 PSN

     UP

• R390 PSY

     UP