Kbase P142567: Should the LBI size drop to zero on RELEASE of the buffers of records that were read with NO-LOCK?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/9/2009 |
|
Status: Unverified
GOAL:
Should the LBI size drop to zero on RELEASE of the buffers of records that were read with NO-LOCK?
GOAL:
Why does the LBI grow if record buffers are not released?
FIX:
Because the record is being accessed with NO-LOCK, no updates or transactions are expected for it, therefore the LBI size will logcally drop down to zero as soon as the buffers are released.
When reading records, if variables are set without the NO-UNDO option, then the variable data will be stored in the LBI until the affected records are released from the buffer. This explains why the LBI grows until the buffer is released, after which it should drop back to its original size