IT08486: AIX-BASED SRA GENERATES CORE DUMP FILES WHEN RUNNING "DEFAULT DBSCAN" AGAINST A MONITORED ORACLE DATABASE.

Tivoli Storage Productivity Center 5.2.7 (select fixes from group)
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)

APAR status

• Closed as program error.

Error description

• SRA scanning an AIX-hosted Oracle database generates core dumps
  while running the Default DB Scan.  Core dumps are created in
  /opt/IBM/TPC/agent/bin and can be large in size.
  Database scan job log reports the DB scan is successful.
  Problem exists in the SRA dbmonitor binary files.  Only external
  symptom is the core dump files being generated.  Core files are
  named similarly to this:  core.xxxxxxx.xxxxxxxx
  RECREATE STEPS:
  Run database scan jobs against an AIX-hosted Oracle instance.
  Observe creation of core dump files.
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   5.2.3
  Agent (OS):   AIX
  ________________________________________________________________
  Problem as described by customer:  Agent application on AIX
  generates core dump
  Initial customer impact (low/med/high):  low
  

Local fix

• Apply fixing SRA code when available.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * TPC 5.2.x users that perform Oracle DB monitoring with trace *
  * enabled.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Performing a probe of an Oracle DB results in a failed probe *
  * and produces a core dump.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fix maintenance when available.                        *
  ****************************************************************
  

Problem conclusion

• Incorrect strings in tracing code in the Oracle probe results in
  segmentation faults when the code is executed.  The fix for this
  APAR is targeted for the following maintenance package:
  
  | refresh pack | 5.2-TIV-TPC-RP0007 - target August 2015
  
  http://www-01.ibm.com/support/docview.wss?&uid=swg21320822
  
  The target dates for future refresh 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

• SRA
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels