Db2 Version 11.5 Mod 5 Fix Pack 0 for Linux, UNIX, and Windows
Db2 Version 11.5 Mod 5 Fix Pack 1 for Linux, UNIX, and Windows
Db2 Version 11.5 Mod 6 Fix Pack 0 for Linux, UNIX, and Windows
Db2 Version 11.5 Mod 7 Fix Pack 0 for Linux, UNIX, and Windows
After upgrading to Db2 v11.5.4, it is possible to see SQL901 errors and engine crashes The known errors are - SQL0901N Reason "Non-SYSTEM tenant for 3rd part name is not supported" - SQL0901N Reason "SYSSEQUENCES is missing row for identity column" - SQL1224 and a trap file from JITS where the top of the stack shows:_ZN12JitsServices17policyAllowsTableEjmm This can only occur if your database was originally created prior to Db2 10.1 GA and you have upgraded this database through subsequent Db2 releases to Db2 11.5. The error occurs because an internal field in the table packed descriptor was not properly initialized in versions prior to Db2 10.1 GA.
Mitigation If you upgraded to Db2 v11.5.4.0 and hitting the issue, you can download and run special version of db2cat tool to fix the issue. Please refer to the following Technote for instructions and download links: https://www.ibm.com/support/pages/node/6246049
This APAR is a duplicate of IT33548
IT33705
DB2 FOR LUW
DB2FORLUW
B50
CLOSED DUB
NoPE
NoHIPER
NoSpecatt / Xsystem
2020-07-27
2020-11-20
2020-11-20