DB2 - Problem description
Problem IT33705 | Status: Closed |
AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
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. | |
Problem Summary: | |
Local Fix: | |
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 | |
Solution | |
Workaround | |
not known / see Local fix | |
Comment | |
This APAR is a duplicate of IT33548 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.07.2020 20.11.2020 20.11.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |