|
Problem IT33548
|
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: |
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: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.5.5.0 or higher *
**************************************************************** |
| Local Fix: |
If you already upgraded to Db2 v11.5.4.0 and hitting the issue,
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 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.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) |
