Direct links to fixes
Tivoli Storage Productivity Center 5.1.1.6
Tivoli Storage Productivity Center Refresh Pack 4
Fix Pack 5.2.4 (November 2014) for Tivoli Storage Productivity Center
Fix Pack 5.2.4.1 (December 2014) for Tivoli Storage Productivity Center
Refresh Pack 5.2.5 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.6 (March 2015) for Tivoli Storage Productivity Center
Fix Pack 5.2.5.1 (April 2015) for Tivoli Storage Productivity Center (withdrawn)
Refresh Pack 5.2.6 (June 2015) for Tivoli Storage Productivity Center
Refresh Pack 5.2.7 (August 2015) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.9 (October 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)
Fix Pack 5.1.1.12 (October 2016) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.13 (February 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.14 (June 2017) for Tivoli Storage Productivity Center
Fix Pack 5.1.1.15 (Sept 2017) for Tivoli Storage Productivity Center
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.1.1.8 (July 2015) for Tivoli Storage Productivity Center
Fix Pack 5.2.7.1 (February 2016) for Tivoli Storage Productivity Center
APAR status
Closed as program error.
Error description
When scanning for used space on Oracle 11g databases, the database scan fails on tables containing LOB declarations. Example: 2014-07-17 15:47:54.198 DBA0040E Error gathering freespace for segment. Name: ************* Type: LOBSEGMENT 2014-07-17 15:47:54.205 DBA0031I Scan aborted 2014-07-17 15:47:54.368 STA0249I Sending results to server 2014-07-17 15:47:57.188 STA0251E Results not saved
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * TPC 5.1.x and 5.2.x users that run scans on Oracle * * tablespace * **************************************************************** * PROBLEM DESCRIPTION: * * While running Oracle tablespace scan the following error * * occurs: * * DBA0038I Scanning tablespace XE.SYSAUX on xe * * DBA0040E Error gathering freespace for segment. Name: * * XDB.SYS_LOB0000014380C00025$$ Type: LOBSEGMENT * * DBA0031I Scan aborted * * STA0249I Sending results to server * * STA0251E Results not saved * **************************************************************** * RECOMMENDATION: * * Apply fix maintenance when available. * ****************************************************************
Problem conclusion
The problem was fixed and scan jobs will run successfully. The fix for this APAR is targeted for the following maintenance package: | fix pack | 5.1.1-TIV-TPC-FP0006 | refresh pack | 5.2-TIV-TPC-RP0004 - target November 2014 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 number
IT03866
Reported component name
TPC
Reported component ID
5608TPC00
Reported release
511
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-08-21
Closed date
2014-10-01
Last modified date
2014-10-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DATA
Fix information
Fixed component name
TPC
Fixed component ID
5608TPC00
Applicable component levels
R511 PSY
UP
R520 PSY
UP
R522 PSY
UP
R521 PSY
UP
R523 PSY
UP
Document Information
Modified date:
22 February 2022