Flashes (Alerts)
Abstract
After a successfully upgrade or update to Db2 v11.5.4 GA release, it is possible to see SQL901 errors and engine crashes.
This document provides an updated version of the db2cat tool, which one can download and execute in order to fix the issue in Db2 v11.5.4 GA release.
One might also avoid this problem by upgrading directly to 11.5.4 Special Build 2983 or o v11.5.5 or later releases, where the issue is fixed by APAR IT33515 (https://www.ibm.com/support/pages/apar/IT33515).
Important: Please note, if you install 11.5.4 Special Build 2983 or install Db2 v11.5.5 or later releases, there is no longer a need for you to run the db2cat tool.
Content
The known errors are:
• SQL0901N The SQL statement or command failed because of a database system error. (Reason "Non-SYSTEM tenant for 3rd part name is not supported".) SQLSTATE=58004
• SQL0901N The SQL statement or command failed because of a database system error. (Reason "SYSSEQUENCES is missing row for identity column".)
• SQL1224 and a trap file from JITS where the top of the stack shows:_ZN12JitsServices17policyAllowsTableEjmm (
JitsServices::policyAllowsTable(unsigned int, unsigned long, unsigned long))
This can only occur if your database was originally created before Db2 v10.1 GA and you have upgraded this database through subsequent Db2 releases to Db2 v11.5.4
The error occurs because an internal field in the table packed descriptor was not properly initialized in versions before Db2 10.1 GA.
Mitigation
If you have already applied Db2 v11.5.4.0 GA and your database meets the criteria mentioned above:
- Download the updated version of the db2cat tool for your operating system using the download link provided below
- Back up the original db2cat/db2cat.exe AND db2cat.bnd into a new directory
- For Linux and UNIX platforms, db2cat is usually under sqllib/bin and db2cat.bnd is under sqllib/bnd
- For Windows platforms, db2cat.exe is usually under DB2\SQLLIB\BIN and db2cat.bnd is under DB2\SQLLIB\bnd
- Replace the existing db2cat binary by copying the new (db2cat/db2cat.exe) to sqllib/bin (DB2\SQLLIB\BIN for Windows) and the new bind file (db2cat.bnd) to the "sqllib/bnd" directory.
- Stop Db2 services.
- Execute "db2cat -d <your database name> -Y" for each Db2 v11.5.4 database.
- The package will auto-bind to your new binary and the new bind file
- "-Y" is a new, undocumented option added to the tool
- db2cat general instructions: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0024085.html
Important: Please note that the tool must be run AFTER you upgrade to version Db2 v11.5.4.0!
Download Links for the updated version of the db2cat tool per operating system:
Linux 64-bit,x86_64
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-linuxx64-db2cat-11.5.4.0-FP000%3A645117534850495616&includeSupersedes=0
Linux 32-bit,x86
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-linuxia32-db2cat-11.5.4.0-FP000%3A718656177591555072&includeSupersedes=0
Linux 64-bit, zSeries
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-linux390x64-db2cat-11.5.4.0-FP000%3A883336181379915392&includeSupersedes=0
AIX 64-bit, pSeries
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-aix64-db2cat-11.5.4.0-FP000%3A507544066329411648&includeSupersedes=0
Linux PPC64LE
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-linuxppc64le-db2cat-11.5.4.0-FP000%3A556077258096983936&includeSupersedes=0
Windows 64-bit, x86
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-ntx64-db2cat-11.5.4.0-FP000%3A446284370046492928&includeSupersedes=0
Windows 32-bit, x86
http://www.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=All&platform=All&function=fixId&fixids=special_2922_2922_DSClients-nt32-db2cat-11.5.4.0-FP000%3A209035782905001344&includeSupersedes=0
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFHEG","label":"DB2 Enterprise Server Edition"},"ARM Category":[{"code":"a8m500000008PkeAAE","label":"Corruption"}],"ARM Case Number":"TS003899188","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
21 February 2022
UID
ibm16246049