|
Problem IT35734
|
Status: Closed |
SYSCODEPROPERTIES CONTINUOUSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem 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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.6 or later *
**************************************************************** |
| Local Fix: |
Recycle the Db2 instance. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to 11.5.6 or later *
**************************************************************** |
| Comment |
Upgrade to 11.5.6 or later |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.01.2021
21.06.2021
28.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
