Kbase 21266: Error (6072) When Using Temporary Tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
SYMPTOM(s):
Application generates large temp tables.
SYSTEM ERROR: error writing, file = <file-name>, ret = <return-value> (6072)
SYSTEM ERROR: error writing file DBIa25248, ret = -1" (6072)
CAUSE:
The DBI files are used to store temporary tables. The temporary tables can grow to a considerable size, and may generate the 6072 error referencing the DBI.
FIX:
The Client session parameter, -Bt, specifies the number of blocks in the buffer for temporary tables. The default value for this parameter is 10. Increase the value of this parameter, or in the case where the client session did not have it, specify this parameter with a value higher than 10.