IT30640: SERVER FAILS TO START AFTER UPGRADE TO 8.1.8.200 WITH SQL0407N ASSIGNMENT OF A NULL VALUE TO A NOT NULL COLUMN

8.1.8.200-IBM-SPSRV-AIX
8.1.8.200-IBM-SPSRV-Linuxx86_64
8.1.8.200-IBM-SPSRV-Linuxppc64le
8.1.8.200-IBM-SPSRV-WindowsX64
8.1.8.200-IBM-SPSRV-Linuxs390x
8.1.9.100-IBM-SPSRV-AIX
8.1.9.100-IBM-SPSRV-Linuxppc64le
8.1.9.100-IBM-SPSRV-Linuxs390x
8.1.9.100-IBM-SPSRV-Linuxx86_64
8.1.9.100-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPSRV-AIX
8.1.10.000-IBM-SPSRV-Linuxppc64le
8.1.10.000-IBM-SPSRV-Linuxs390x
8.1.10.000-IBM-SPSRV-Linuxx86_64
8.1.10.000-IBM-SPSRV-WindowsX64
8.1.10.000-IBM-SPCMS-Linuxx86_64
8.1.10.000-IBM-SPCMS-WindowsI32
8.1.10.000-IBM-SPCMS-WindowsX64
8.1.10.000-IBM-SPOC-AIX
8.1.10.000-IBM-SPOC-LinuxPPC64le
8.1.10.000-IBM-SPOC-Linuxs390x
8.1.10.000-IBM-SPOC-Linuxx86_64
8.1.10.000-IBM-SPOC-WindowsX64
IBM Spectrum Protect Server V8.1.8.X interim fix downloads
IBM Spectrum Protect Server V8.1 Fix Pack (V8.1.10) Downloads

APAR status

• Closed as program error.

Error description

• Upgrade of the server to 8.1.9.000 completes without failure
  however on restart of the server process the following error may
  be encountered.
  
  Upgrades from the following levels and higher will be affected
  IF a storage rule is defined to the server:
  8.1.7.019, 8.1.8.016 and 8.1.8.200
  
  IBM Spectrum Protect for Linux/x86_64
  Version 8, Release 1, Level 9.000
  
  Licensed Materials - Property of IBM
  
  (C) Copyright IBM Corporation 1990, 2019.
  All rights reserved.
  U.S. Government Users Restricted Rights - Use, duplication or
  disclosure
  restricted by GSA ADP Schedule Contract with IBM Corporation.
  
  ANR7801I Subsystem process ID is 16151.
  ANR0900I Processing options file /tsm81/instance/dsmserv.opt.
  ANR7814I Using instance directory /tsm81/instance.
  ANR3339I Default Label in key data base is TSM Server SelfSigned
  SHA Key.
  ANR4726I The ICC support module has been loaded.
  ANR0990I Server restart-recovery in progress.
  ANR0152I Database manager successfully started.
  ANR1628I The database manager is using port 51500 for server
  connections.
  ANR0275I Detected schema change for table SC.Storage.Classes,
  attempting to reconcile.
  ANR0162W Supplemental database diagnostic information:
  -1:23502:-407 ([IBM][CLI Driver][DB2/LINUXX8664] SQL0407N
  Assignment of a NULL value to a NOT NULL column
  "TBSPACEID=2, TABLEID=286, COLNO=XX" is not allowed.
  SQLSTATE=23502
  ).
  ANR0277E Schema reconciliation for table SC.Storage.Classes
  failed.
  ANR0369I Stopping the database manager because of a server
  shutdown.
  ANR0991I Server shutdown complete.
  
  The issue has been observed on Linux but will affect all
  supported platforms.
  
  Upgrades from the following levels will be affected IF a storage
  rule is defined to the server:
  8.1.7.019, 8.1.8.016 and 8.1.8.200
  

Local fix

• If the problem is encountered when upgrading to version
  8.1.9.000, issue the following commands to allow server startup.
   Note that some steps may result in an error, but proceed with
  the entire plan:
  db2 connect to tsmdb1
  db2 alter table tsmdb1.sc_storage_classes drop column
  excludeprotstats
  db2 alter table tsmdb1.sc_storage_classes_bad drop column
  excludeprotstats
  db2 reorg table tsmdb1.sc_storage_classes
  db2 reorg table tsmdb1.sc_storage_classes_bad
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 8.1.7.100, 8.1.8.200,        *
  * 8.1.9.100, and 8.1.10.000 Note that this is subject to       *
  * change at the discretion of IBM.                             *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  Platforms fixed:  AIX, Linux, and Windows.
  

Temporary fix

• If the problem is encountered when upgrading to version
  8.1.9.000, issue the following commands to allow server startup:
  db2 connect to tsmdb1
  db2 alter table tsmdb1.sc_storage_classes drop column
  excludeprotstats
  db2 alter table tsmdb1.sc_storage_classes_bad drop column
  excludeprotstats
  db2 reorg table tsmdb1.sc_storage_classes
  db2 reorg table tsmdb1.sc_storage_classes_bad
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels