DB2 - Problem description
Problem IT35933 | Status: Closed |
SYSCODEPROPERTIES CONTINUONSLY 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: * * Install DB2 11.5 mod pack 5 fixpack 1 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Install DB2 11.5 mod pack 5 fixpack 1 * **************************************************************** | |
Comment | |
Install DB2 11.5 mod pack 5 fixpack 1 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.02.2021 08.04.2021 08.04.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |