IT46028: SERVER STARTUP AFTER AN UPGRADE TO 8.1.22 MAY TAKE LONG TIME WITH DB2 GENERATING FODC_APPERR COLLECTIONS

APAR status

• Closed as unreproducible.

Error description

• After an IBM Storage Protect Server upgrade to 8.1.22, it may
  take a long time (the timing varies depending on the system, and
  it can take from an hour, several hours or even more) for
  startup to complete, while DB2 will generate large amount of
  FODC_AppErr data collections in the dump location that could
  result in the file system full condition.
  
  
  The db2diag log will show the following:
  
  ****
  2024-04-10-15.59.24.644000+120 I12306351F969        LEVEL:
  Severe
  PID     : 4820                 TID : 9004           PROC :
  db2syscs.exe
  INSTANCE: SERVER1              NODE : 000           DB   :
  TSMDB1
  APPHDL  : 0-341                APPID:
  *LOCAL.SERVER1.240410135805
  UOWID   : 3                    ACTID: 1
  AUTHID  : TSMINST1                HOSTNAME: Hostname
  EDUID   : 9004                 EDUNAME: db2agent (TSMDB1)
  FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
  probe:300
  DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
  sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -901   sqlerrml: 35
  sqlerrmc: Inc bind section statement changed!
  sqlerrp : SQLRA0FC
  sqlerrd : (1) 0x00000000      (2) 0x00000000      (3) 0x00000000
  
            (4) 0x00000000      (5) 0xFFFFFF6A      (6) 0x00000000
  
  sqlwarn : (1)      (2)      (3)      (4)        (5)       (6)
            (7)      (8)      (9)      (10)        (11)
  sqlstate:
  
  2024-04-10-15.59.24.644000+120 I12307322F232      LEVEL: Severe
  
  PID:4820 TID:9004 NODE:000 Title: SQLCA
  Dump File:C:\ProgramData\IBM\DB2\DB2TSM1\SERVER1\FODC_AppErr_20
  24-04-10-15.59.24.628002_4820_9004_000\4820.9004.000.dump.bin
  ****
  
  
  
  Note the Inc bind section statement changed! and the
  FODC_AppErr messages. These are indications of the DB2 issue
  DT259574.
  
  
  -901 "Inc bind section statement changed!" and FODC_AppErr
  after installing Cumulative Special Build
  https://www.ibm.com/mysupport/s/defect/aCI3p0000008dlYGAQ/dt259
  574?language=en_US
  
  
  IBM Storage Protect Versions Affected:
  IBM Storage Protect Server 8.1.22 on all supported platforms
  
  
  Additional Keywords:
  Storage Protect; TS015953618; startup; hang; DB2; FODC_AppErr;
  Inc bind section statement changed; -901;
  

Local fix

• Run the bind manually. The DB2 must be running, therefore if the
  instance is stopped, issue db2start first then perform the
  corrective action.
  
  Windows:
  From DB2 Administrative Command Window:
  
  
  db2 connect to tsmdb1
  db2 bind 'C:\Progra~1\Tivoli\TSM\DB2\bnd\db2schema.bnd'
  
  
  Note: This is an example for default installation. If an
  alternate location was used, replace the above path with actual
  path to the db2schema.bnd.
  
  Linux/AIX:
  As instance user:
  
  
  db2 connect to tsmdb1
  db2 bind <INSTHOME>/sqllib/bnd/db2schema.bnd
  
  
  Where <INSTHOME> is a home directory of the instance user.
  
  The FODC_AppErr* collections can be safely deleted. On Windows
  they will be located in the
  c:\ProgramData\IBM\DB2\DB2TSM1\SERVER1 and on Linux/AIX in the
  <INSTHOME> /sqllib/db2dump/DIAG0000 directory.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * None                                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SERVER STARTUP AFTER AN UPGRADE TO 8.1.22 MAY TAKE LONG TIME *
  * WIT H DB2 GENERATING FODC_APPERR COLLECTIONS                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

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:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels