Kbase P66690: Why are my lbi files growing substantially?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Why are my lbi files growing substantially?
GOAL:
Why are the Temp files growth consuming all the disk space?
FIX:
Files whose names begin with "lbi" are 4GL local-before-image files used to hold subtransaction data (for example, subtransaction undo etc).
Progress uses this file type to support the back-out of subtransaction and variables. If the number of lbi files grows too large, the procedures are using a lot of subtransaction .
If the client is running low on space in the directory they are writing the temp files to (working directory by default if not using the -T), the files can be moved by changing the directory on the -T startup parameter on the client or some space can be freed up in the local directory.
The code can also be revisited to eliminate some of the subtransaction . Adding NO-UNDO to definitions of variables and Temp tables will help.