IV12640: SLOW RESPONSE TIME WHEN DISPLAYING/MODIFYING HISTORICAL SETTINGS

IBM Tivoli Monitoring 6.2.2 Fix Pack 8 (6.2.2-TIV-ITM-FP0008)
IBM Tivoli Monitoring 6.2.2 Fix Pack 9 (6.2.2-TIV-ITM-FP0009)

APAR status

• Closed as program error.

Error description

• When modifying or displaying Historical collection settings, the
  display refresh can take an inordinate amount of time.  The root
  cause of the problem has not yet been identified.  Detailed
  recreate instructions are not yet available.  At this point, the
  problem either happens or it doesn't.
  

Local fix

Problem summary

• When displaying or configuring Historical collection,
  particularly when the agent has a large number of attribute
  groups, the time it takes to display the attribute groups can
  take a long time.  Other factors contributing to an increase in
  time would be the warehouse data base on a remote system and the
  historical collection settings have been migrated to the
  WAREHOUSESUMPRUNE table.  With slow network and/or slow data
  base response time.
  
  The existing portal server code issues an SQL SELECT for each
  table (ie.  attribute group) of any particular agent type.  If
  there are a small number of agent types, this will not take an
  inordinate amount of time, but when there are a large number of
  agent tables an SQL SELECT is issued for each table.  This was
  reported for a customer that had 1700 separate agent tables (ie.
  attribute groups) with an average of about 2 or 3 SQL SELECTS
  per second, it could take 9 - 12 minutes for the collection
  settings to be displayed.
  

Problem conclusion

• Changed the code to issue single SQL request for the entire
  table and then iterate through the results to find the
  collection settings.
  
  
  The fix for this APAR is contained in the following maintenance
  packages:
  
    | fix pack | 6.2.2-TIV-ITM-FP0008
    | fix pack | 6.2.3-TIV-ITM-FP0002
  

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

  TEPS

• Fixed component ID

  5724C04PS

Applicable component levels

• R622 PSY

     UP