SQL0901N Reason "Non-SYSTEM tenant for 3rd part name is not supported"
2022/2/19 2:11:47
本文主要是介绍SQL0901N Reason "Non-SYSTEM tenant for 3rd part name is not supported",对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
IT33705: AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES
Fixes are available
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
APAR status
-
Closed as duplicate of another APAR.
Error 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.
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
Problem summary
Problem conclusion
Temporary fix
Comments
-
This APAR is a duplicate of IT33548
APAR Information
-
APAR number
IT33705
-
Reported component name
DB2 FOR LUW
-
Reported component ID
DB2FORLUW
-
Reported release
B50
-
Status
CLOSED DUB
-
PE
NoPE
-
HIPER
NoHIPER
-
Special Attention
NoSpecatt / Xsystem
-
Submitted date
2020-07-27
-
Closed date
2020-11-20
-
Last modified date
2020-11-20
-
APAR is sysrouted FROM one or more of the following:
-
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
这篇关于SQL0901N Reason "Non-SYSTEM tenant for 3rd part name is not supported"的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-05-01为什么公共事业机构会偏爱 TiDB :TiDB 数据库在某省妇幼健康管理系统的应用
- 2024-04-26敏捷开发:想要快速交付就必须舍弃产品质量?
- 2024-04-26静态代码分析的这些好处,我竟然都不知道?
- 2024-04-26你在测试金字塔的哪一层?(下)
- 2024-04-26快刀斩乱麻,DevOps让代码评审也自动起来
- 2024-04-262024年最好用的10款ER图神器!
- 2024-04-2203-为啥大模型LLM还没能完全替代你?
- 2024-04-2101-大语言模型发展
- 2024-04-17基于SpringWeb MultipartFile文件上传、下载功能
- 2024-04-14个人开发者,Spring Boot 项目如何部署