IV03968: BACKUP POLLER WILL ATTEMPT TO TRUNCATE NCPOLLDATA.POLLDATA WHEN NOT ACTING PRIMARY.

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
IBM Tivoli Network Manager IP 3.9.0 Fix Pack 3, 3.9.0-TIV-ITNMIP-FP0003
IBM Tivoli Network Manager IP 3.9.0 Fix Pack 4, 3.9.0-TIV-ITNMIP-FP0004
IBM Tivoli Network Manager IP Edition 3.9.0 Fix Pack 5, 3.9.0-TIV-ITNMIP-FP0005

APAR status

• Closed as program error.

Error description

• Product: Tivoli Network Manager
  Version: 3.8
  Component: ncp_poller
  
  Symptoms:
  In a failover environment, the backup poller will attempt to
  truncate the stored data in ncpolldata.polldata at the same time
  as the Primary poller is taking the same action.  This can cause
  a deadlock on the database.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * 3.8, 3.9 all platforms, users of Oracle as NCIM in           *
  * particular                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * in failover mode, backup poller tries to delete data from    *
  * ncpolldata schema even when the primary poller is active     *
  * leading to a potential deadlock in Oracle                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * install 3.8 fix pack 7 or 3.9 fix pack 1 or APAR IV03968     *
  * 3.9.0-TIV-ITNMIP-FP0001                                      *
  * 3.8.0-TIV-ITNMIP-FP0007                                      *
  ****************************************************************
  

Problem conclusion

• | fix pack | 3.8.0-ITNMIP-FP0007
  | fix pack | 3.9.0-ITNMIP-FP0001
  

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 PSY

     UP

• R390 PSY

     UP