IT13112: TRANSACTION LOGS EXHAUST AVAILABLE DISK SPACE WHEN ISSUING "SET INTEGRITY" AGAINST THE T_RPT_HOST_KEYS TABLE, 5.2.5 TO 5.2.7

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 Permanent restriction.

Error description

• 5.2.5 ->5.2.7 upgrade on AIX.  Upgrade fails during dbschema
  upgrade (msgTPCInstall.log):
  2015-12-08 08:53:38.938-0600 BPCIN0116I The system is upgrading
  the Database repository component.
  2015-12-08 09:04:29.846-0600 BPCIN0108E An error occurred during
  the upgrade of the Database repository. Review the log files in
  the following directory for an explanation of the error:
  /opt/IBM/TPC/logs.
  Corresponding traceTPCInstall.log entries:
  2015-12-08 11:08:06.611-0600 INFO error will not be ignored
  2015-12-08 11:08:06.612-0600 INFO DEBUG SDI ignoreSqlError exit
  ignore = false
  2015-12-08 11:08:06.711-0600 INFO
  2015-12-08 11:08:06.513-0600 INS2070E: SQL Error encountered
  during repository creation. 2015-12-08 11:08:06.711-0600 INFO
  SQL statement: SET INTEGRITY FOR
  2015-12-08 11:08:06.711-0600 INFO SQLSTATE: 57011, Vendor error
  code: -968
  2015-12-08 11:08:06.711-0600 INFO DB2 SQL Error: SQLCODE=-968,
  SQLSTATE=57011, SQLERRMC=null, DRIVER=3.65.77 2015-12-08
  11:08:06.711-0600 INFO
  com.tivoli.itsrm.install.SilentInstallException:
  2015-12-08 11:08:06.663-0600 INS2071E: Error creating JDBC SQL
  Statement.
  RECREATE STEPS:
  Apply 5.2.7 upgrade to 5.2.5 server
  ________________________________________________________________
  DB2 Version used for Server:    N/A
  The defect is against component:   5608TPC00
  Server/Manager build/release (TPC):   5.2.7
  __________________________________________________
  Problem as described by customer:   5.2.7 upgrade failed
  Initial customer impact (low/med/high): med
  

Local fix

• Contact support for workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Certain users in a rare situation upgrading to a TPC or IBM  *
  * Spectrum Control 5.2.x level                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Transaction logs exhaust available disk space.  See ERROR    *
  * DESCRIPTION.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Contact IBM Support for recovery options.  If you've hit     *
  * this problem and recovered before, contact IBM Support       *
  * before attempting future upgrades for a possible             *
  * circumvention to avoid failure during the upgrade.           *
  ****************************************************************
  

Problem conclusion

• This situation cannot be resolved at this time but can be
  recovered if it does occur.
  

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

• INSTALL
  

Fix information

Applicable component levels