IT05448: THE REPORT "PERFORMANCE DATA EXPORT" FOR SVC VOLUMES FAILS AND FILLS ALL DB2 TEMPORARY SPACE.

Tivoli Storage Productivity Center Refresh Pack 5
Refresh Pack 5.2.5 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.2.5.1 (April 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.6 (June 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.7 (August 2015) for Tivoli Storage Productivity Center
IBM Spectrum Control V5.2.8 (December 2015)
IBM Spectrum Control V5.2.9 (February 2016)
IBM Spectrum Control V5.2.10 (May 2016)
IBM Spectrum Control V5.2.10.1 (July 2016)
IBM Spectrum Control V5.2.11 (August 2016)
IBM Spectrum Control V5.2.12 (November 2016)
IBM Spectrum Control V5.2.13 (March 2017)
IBM Spectrum Control V5.2.14 (May 2017)
IBM Spectrum Control V5.2.15 (August 2017)
IBM Spectrum Control V5.2.15.2 (November 2017)
IBM Spectrum Control V5.2.16 (March 2018)
IBM Spectrum Control V5.2.17 (May 2018)
Fix Pack 5.2.7.1 (February 2016) for Tivoli Storage Productivity Center

APAR status

• Closed as program error.

Error description

• When run the report: "Performance Data Export" the partition
  runs full, where the DB2 instance TPCDB is.
  The "Performance Data Export" fails with the following
  exception:
  SQL0968C  The file system is full. SQLSTATE=57011
  
  RECREATE STEPS:
  Reporting > View Predefined Reports > Storage Systems >
  Performance Data Export.
  The report will fail for the following configuration:
  Storage system: select a SVC storage subsystem with performance
  data collected over a period of at least two months.
  Interval: Sample
  Reporting period: Custom data range
  From - To:  any interval ( one hour is enough to break the
  report )
  Performance metrics: Volumes
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.2.x users running the report "Performance Data Export" *
  * for volume metrics.                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available.                        *
  ****************************************************************
  

Problem conclusion

• Incomplete JOIN  condition generated large amount of unuseful
  rows which filled in the DB2 temporary space.
  The JOIN condition has been fixed.
  The fix for this APAR is targeted for the following maintenance
  package:
  
  | refresh pack | 5.2-TIV-TPC-RP0005 - target March 2015
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future refresh packs or 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:

Modules/Macros

• Reports
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels