Kbase P115577: Excessive space usage for some tables in type II storage areas
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/03/2011 |
|
Status: Verified
SYMPTOM(s):
Excessive space usage for some tables in type II storage areas
Database engine does not re-use the space within Type II storage areas after records have been deleted.
Multiple users deleting and inserting large amounts of records from one table simultaneously.
This table resides in a Type II storage area that exhibits the excessive space usage.
Physical storage area growth does not equate to tabanalys reports
FACT(s) (Environment):
OpenEdge 10.0x
OpenEdge 10.1A
All Supported Operating Systems
CAUSE:
Bug# OE00128403
CAUSE:
The internal cluster allocation algorithm was modified to single threaded at the per table level for a type II storage areas to avoid excessive growth. It was found that when mutliple users were inserting records to the same object in a Type II storage area at the same time, one user can sometimes steal the block off the rmchain a different user is waiting for, which cause the storage area can grow in excess of the actual space needed to complete the operation.
FIX:
While this issue was first addressed in OpenEdge 10.0B05, 10.1A02 and 10.1B, it is recommended to upgrade to OpenEdge 10.1B02 where further improvements were added for high volume multi-user updates. See Solution P123316 "Type II Storage area - space allocation issue with creates and updates." for further information in this regard.
While applying the SP is not possilbe, and if space usage becomes critical, another possibility is to perform a tablemove into a Type I storage area.