IV20360: $PRECISIION_HOME/PRODUCTS/TNM/BIN/ITNM_POLLDATA_PRUNINGSCRIPT T AKES 3 DAYS TO PRUNE POLLDATA WHEN IT IS LARGE.

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 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