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 number
IT46028
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
81W
Status
CLOSED UR3
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-04-26
Closed date
2024-06-25
Last modified date
2024-06-25
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
[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81W"}]
Document Information
Modified date:
25 June 2024