Direct links to fixes
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
itnm_polldataPrune.jar -> PrunePollData.class uses JOINs which cause Informix to delete entries very slowly from pollData. To simplify the deletes, we need to make a schema change. This is something we are considering for a future Fix Pack as it wil l allow us to simplify the ITM Agent as well as the pruning from ncpolldata. (Dev engineers)
Local fix
Use "truncate" and "optimize" equivalents in Informix to remove data from pollData quickly.
Problem summary
**************************************************************** * USERS AFFECTED: * * The users using the script itnm_polldata_pruning to delete * * data from table pollData * **************************************************************** * PROBLEM DESCRIPTION: * * The script performance on informix is slow due to usage of * * complex queries and INNER JOINS on DELETE statements. * **************************************************************** * RECOMMENDATION: * * | fix pack | 3.9.0-ITNMIP-FP0002 * * Replace the tool file at * * $PRECISIION_HOME/products/tnm/lib/itnm_polldataPrune.jar * * with the updated version. * * | fix pack | 3.8.0-ITNMIP-FP0007 * ****************************************************************
Problem conclusion
The script itnm_polldata_pruning that deletes data from polldata table used a complex query to return the data and also called the JDBC deleteRow that is not efficient when doing large delete sets.The query that retrieves data was changed to to be simpler, called less often and to do delete on chunks of 50 rows. This changes improved significantly the script performance.
Temporary fix
Comments
APAR Information
APAR number
IV20360
Reported component name
TIV NETWK MGR I
Reported component ID
5724S4500
Reported release
390
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-30
Closed date
2012-05-18
Last modified date
2013-04-03
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
R390 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHRK","label":"Tivoli Network Manager IP Edition"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.9","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
03 April 2013