IT35734: SYSCODEPROPERTIES CONTINUOUSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING

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
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• db2pd -d ... -catalogcache  output reports a large number of
  invalid
  routines in  SYSCODEPROPERTIES
  This number continuously increase without reducing (in the
  specific Case it reached the number near to 60000 objects) and
  they consume CATALOG CACHE heap penalizing performance.
  

Local fix

• Recycle the Db2 instance.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.5.6 or later                                   *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.5.6 or later
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB50 PSN

     UP