Kbase P37926: DBI files grow when temp-tables are not destroyed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/05/2009 |
|
Status: Unverified
FACT(s) (Environment):
Sun Solaris SPARC
Progress 9.1D
SYMPTOM(s):
Error 40 running an application.
SYSTEM ERROR: Attempt to define too many indexes. (40)
DBI files are not reusing space from temp tables, causing growth on DBI file.
Running a program that uses static TEMP-TABLEs.
TEMP-TABLEs are defined as NO-UNDO.
No dynamic TEMP-TABLEs are involved.
TEMP-TABLEs are passed as OUTPUT TABLE parameter between programs.
CAUSE:
Temp-tables are not being destroyed.
FIX:
Destroy the temp-tables being passed between program to cause the DBI files to grow at a slower rate. Restart the batch clients every 24 hours or so in order to prevent the DBI files from growing too large.