IT03866: ERROR DBA0040E IN TPC WHILE SCANNING ORACLE TS /TABLES CONTAINING LOBS

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 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