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