IC74982: DISK MANAGER REPORT QUERY TAKES LONG TIME TO GENERATE.

4.2.1 Interim Fix 1 (November 2011) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• Disk Manager > Reporting > Storage Subsystems > Computer Views >
  By Filesystem/Logical Volume
  Current generation time equals 7+ minutes, when report should
  run in less than 1 minute.
  RECREATE STEPS:
  Generate Report: Disk Manager > Reporting > Storage Subsystems >
  Computer Views > By Filesystem/Logical Volume
  The SMI-S Agent for DB2 Version used for Server:  n/a
  The defect is against component:  5608TC100
  Server/Manager build/release (TPC):  4.1.185
  Agent build/release (TPC):  n/a
  Server/Manager (OS): Linux (n/a): WIN
  Agent (OS):  n/a
  

Local fix

• Request Patch from Support
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: TPC 4.1.0, 4.1.1, 4.2.0 and 4.2.1 users      *
  *                 running Disk Manager reports                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: Disk Manager reports are too slow to    *
  *                      generate when using VIO clients and     *
  *                      VIO servers.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  -
  

Problem conclusion

• Optimized the query to allow the report to generate faster.
  The fix for this APAR is targeted for the following maintenance
  packages:
  
  | fix pack | 4.1.1-TIV-TPC-FP0007 - target to be determined
  | fix pack | 4.2.1-TIV-TPC-FP0003 - target June 2011
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future fix packs do not represent a formal
  commitment by IBM. The dates are subject to change without
  notice.
  

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

  TPC FOR DATA

• Fixed component ID

  5608TC300

Applicable component levels

• R41A PSY

     UP

• R41L PSY

     UP

• R41W PSY

     UP

• R42A PSY

     UP

• R42L PSY

     UP

• R42W PSY

     UP