DB2 FOR LUW / DB2FORLUW / B50 - DB2

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.

****************************************************************
* USERS AFFECTED:                                              *
* all                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.5.5.0 or higher                            *
****************************************************************

Mitigation
If you have already applied Db2 v11.5.4.0 and your
database meets the criteria mentioned above:

1.Download the
updated version of the db2cat tool for your operating system
using the download link provided below
2. Backup the original
db2cat/db2cat.exe AND db2cat.bnd into a new directory
2a.For
Linux and UNIX platforms, db2cat is usually under sqllib/bin
and db2cat.bnd is under sqllib/bnd
2b.For Windows platforms,
db2cat.exe is usually under DB2SQLLIBBIN and db2cat.bnd is
under DB2SQLLIBnd
3. Replace the existing db2cat executable
by copying the new executable (db2cat/db2cat.exe) to sqllib/bin
(DB2SQLLIBBIN for Windows) and the new bind file (db2cat.bnd)
to the bnd directory under the sqllib directory.
4. Execute
"db2cat -d  -Y" for each Db2 v11.5.4
database.
4a. The package will auto-bind to your new executable
and new bnd file
4b. "-Y" is a new, undocumented option we have
added
4c. db2cat general instructions: https://www.ibm.com/suppo
rt/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.admin.cmd.doc/d
oc/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/fixcent
ral/swg/quickorder?parent=ibm~Information%2BManagement&product=i
bm/Information+Management/IBM+Data+Server+Client+Packages&releas
e=All&platform=All&function=fixId&fixids=special_2922_2922_DSCli
ents-linuxx64-db2cat-11.5.4.0-FP000%3A645117534850495616&include
Supersedes=0

Linux 32-bit,x86

http://www.ibm.com/support/fixce
ntral/swg/quickorder?parent=ibm~Information%2BManagement&product
=ibm/Information+Management/IBM+Data+Server+Client+Packages&rele
ase=All&platform=All&function=fixId&fixids=special_2922_2922_DSC
lients-linuxia32-db2cat-11.5.4.0-FP000%3A718656177591555072&incl
udeSupersedes=0

Linux 64-bit,zSeries

http://www.ibm.com/suppor
t/fixcentral/swg/quickorder?parent=ibm~Information%2BManagement&
product=ibm/Information+Management/IBM+Data+Server+Client+Packag
es&release=All&platform=All&function=fixId&fixids=special_2922_2
922_DSClients-linux390x64-db2cat-11.5.4.0-FP000%3A88333618137991
5392&includeSupersedes=0

AIX 64-bit, pSeries

http://www.ibm.co
m/support/fixcentral/swg/quickorder?parent=ibm~Information%2BMan
agement&product=ibm/Information+Management/IBM+Data+Server+Clien
t+Packages&release=All&platform=All&function=fixId&fixids=specia
l_2922_2922_DSClients-aix64-db2cat-11.5.4.0-FP000%3A507544066329
411648&includeSupersedes=0

Linux PPC64LE

http://www.ibm.com/su
pport/fixcentral/swg/quickorder?parent=ibm~Information%2BManagem
ent&product=ibm/Information+Management/IBM+Data+Server+Client+Pa
ckages&release=All&platform=All&function=fixId&fixids=special_29
22_2922_DSClients-linuxppc64le-db2cat-11.5.4.0-FP000%3A556077258
096983936&includeSupersedes=0

Windows 64-bit, x86

http://www.i
bm.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=s
pecial_2922_2922_DSClients-ntx64-db2cat-11.5.4.0-FP000%3A4462843
70046492928&includeSupersedes=0

Windows 32-bit, x86

http://www
.ibm.com/support/fixcentral/swg/quickorder?parent=ibm~Informatio
n%2BManagement&product=ibm/Information+Management/IBM+Data+Serve
r+Client+Packages&release=All&platform=All&function=fixId&fixids
=special_2922_2922_DSClients-nt32-db2cat-11.5.4.0-FP000%3A209035
782905001344&includeSupersedes=0

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

12.07.2020
20.11.2020
20.11.2020