IV10023: THE VIEW NCPOLLDATA.POLLITEMVIEW DO NOT RETURN IP ADDRESS

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

APAR status

• Closed as program error.

Error description

• v3.8 (applicable for all fixpacks upto FP6) - platform
  independent.
  
  The view ncpolldata.pollItemView do not return ip address for
  chassis and break reports because the below line from
  "createPollDataDb.sql" definition is not correct:
  
  i.accessIPAddress AS IP_ADDRESS
  
  It needs to set chassis ip when there is no ip for an interface
  i.e.
  COALESCE(i.accessIPAddress, c.accessIPAddress) AS IP_ADDRESS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All ITNM 3.8 report users.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The view ncpolldata.pollItemView and                         *
  * ncpolldata.KNP_POLL_DATA_COLLECTION do not return IP address *
  * for chassis and this data is not shown on reports because    *
  * the below line from                                          *
  * "createPollDataDb.sql" definition is not correct:            *
  *                                                              *
  * i.accessIPAddress AS IP_ADDRESS                              *
  *                                                              *
  * It needs to set chassis IP Address when there is no IP for   *
  * an interface                                                 *
  * i.e.                                                         *
  * COALESCE(i.accessIPAddress, c.accessIPAddress) AS IP_ADDRESS *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * | fix pack | 3.8.0-ITNMIP-FP0007                             *
  ****************************************************************
  

Problem conclusion

• When the views are updated with the chassis IP Address it will
  show on the reports.
  

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

  TIV NETWK MGR I

• Fixed component ID

  5724S4500

Applicable component levels