|
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) |
