Kbase P137157: Seeing a lot of dbi file growth and dbi file is not deleted
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2009 |
|
Status: Verified
SYMPTOM(s):
Seeing a lot of dbi file growth
The dbi file is growing large
The dbi file is not deleted
FACT(s) (Environment):
All temp-tables are deleted
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.1x
CAUSE:
This is expected behavior
FIX:
The DBI file is created by the client/AppServer when the first temp-table is created (static or not) and the DBI file will remain on the system until that client/server exits normally. The file never shrinks or gets deleted otherwise. You don't have to restart the broker, but trim the servers to see the temp files go away.
As for the size of the file, the file will be as big as needed to store temp-tables and their records at any given time. So depending on how many temp-tables and records are involved, the size you are seeing is ok. If temp-tables are not getting deleted, the DBI file will keep growing, and you will eventually see an error when we create too many temp-tables on a given session. If the DBI file size stabilizes, then there is no issue.