PK90883: SLOW RESPONSE AND HIGH CPU WITH QUERY USING VOLUMES

IBM Tivoli Storage Manager V6.1 Fix Pack 3 (6.1.3) Server Downloads
Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• PK62160 improved performance of queries using volume data, but
  high cpu and slow response times still exist. After further
  analysis, additional improvements in performance and reduction
  of cpu utilization can be made by changing the design of the
  routine that builds internal lists of volumes by eliminating
  iterative calls when copying data in memory.
  .
  Additional Keywords: NODEDATA VOLUMEUSAGE
  

Local fix

• Review the command for additional parameters that can be used to
  reduce the number of volumes being selected, such as STGPOOL or
  a wildcard on VOLUME.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users of   *
  *                 SELECT statement against VOLUMEUSAGE table   *
  *                 with a large number of volumes and nodes.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: See ERROR DESCRIPTION.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in levels 5.5.4 and 6.1.3. Note that this    *
  *                 is subject to change at the discretion of    *
  *                 IBM.                                         *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux, z/OS, and
  Windows.
  

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

  TSM FOR OS/390

• Fixed component ID

  5698ISMVS

Applicable component levels

• R550 PSY UK52124

     UP09/11/20 P F911

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.