Direct links to fixes
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 number
IV10023
Reported component name
TIV NETWK MGR I
Reported component ID
5724S4500
Reported release
380
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-11-01
Closed date
2011-11-10
Last modified date
2011-11-10
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"380","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"}}]
Document Information
Modified date:
11 September 2024