DB2 - Problem description
Problem IT37991 | Status: Closed |
SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Under certain conditions, space used by lobs in some event monitor tables will not reused when those lobs are deleted. This may cause the table spaces containing those event monitor tables to become full. Note that this APAR impacts only the following event monitor types: * Activity event monitor * Unit of work event monitor * Package cache event monitor * Locking event monitor * Statistics event monitor * Change history event monitor * Threshold violations event monitor | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Local Fix: | |
Periodically deactivate and reactivate event monitors. This will allow freed lob storage to be reused. Alternatively if the LOB columns in the event monitor target tables do not capture any data of interest, create the event monitor tables without those columns. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 11.1.4.7 * **************************************************************** | |
Comment | |
Upgrade to 11.1.4.7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.08.2021 17.04.2022 17.04.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |