IT16800: IBM SPECTRUM CONTROL DATABASE REPOSITORY UPGRADE MAY FAIL WITH ERROR BPCIN0108E DUE TO INVALID OR INOPERATIVE VIEWS.

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

• During the IBM Spectrum Control upgrade the error is displayed:
  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: <TPC_install_path>\logs.
  
  The errors are seen in the traceTPCInstall.log:
  2016-08-24 11:16:54.354-0400 INFO   2016-08-24 11:16:54.260-0400
  INS2108E: SQL Error encountered during repository uninstallation
       [java]                          SQL statement: select
  tabschema, tabname from syscat.tables where type = 'T' and
  tbspace = 'TPCTBSPDATA' and  tabschema = 'TPC'
  2016-08-24 11:16:54.354-0400 INFO                            SQL
  statement: select tabschema, tabname from syscat.tables where
  type = 'T' and tbspace = 'TPCTBSPDATA' and  tabschema = 'TPC'
       [java]                                      SQLSTATE:
  51024, Vendor error code: -575
  2016-08-24 11:16:54.354-0400 INFO
  SQLSTATE: 51024, Vendor error code: -575
       [java]                                      DB2 SQL Error:
  SQLCODE=-575, SQLSTATE=51024,
  SQLERRMC=TPC.T_VIEW_VZONE2MEMBER_SNAPSHOT, DRIVER=3.65.77
  2016-08-24 11:16:54.354-0400 INFO
  DB2 SQL Error: SQLCODE=-575, SQLSTATE=51024,
  SQLERRMC=TPC.T_VIEW_VZONE2MEMBER_SNAPSHOT, DRIVER=3.65.77
       [java] com.tivoli.itsrm.install.SilentInstallException:
  2016-08-24 11:16:54.260-0400 INS2071E: Error creating JDBC SQL
  Statement.
  2016-08-24 11:16:54.354-0400 INFO
  com.tivoli.itsrm.install.SilentInstallException: 2016-08-24
  11:16:54.260-0400 INS2071E: Error creating JDBC SQL Statement.
  
  The root cause is due to invalid or inoperative views in TPCDB.
  
  All TPC/IBM Spectrum Control may be affected.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Those upgrading to IBM Spectrum Control or TPC 5.2.x         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Upgrade fails when some DB2 views are inoperative.  See      *
  * ERROR DESCRIPTION                                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 5.2.12 fix maintenance when available instead.    *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is targeted for the following maintenance
  package:
  
  | refresh pack | 5.2-TIV-TPC-RP0012 - target November 2016
  
  Fixed in IBM Spectrum Control 5.2.12.
  
  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

• INSTALL
  

Fix information

• Fixed component name

  TPC

• Fixed component ID

  5608TPC00

Applicable component levels

• R529 PSY

     UP

• R52A PSY

     UP

• R52B PSY

     UP