Kbase P13702: Error# 8898 on temp table file (.dbi).
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2003 |
|
Status: Unverified
SYMPTOM(s):
Running an application that uses a lot of temporary tables.
SYSTEM ERROR: Attempted to exceed 2GB limit with file dbi + <some-number>.
(8898)
CAUSE:
The DBI files are used to store temporary tables. The temporary tables can grow to a considerable size, and may generate the 8898 error referencing the DBI file.
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 does not make use of it, specify this parameter with a value higher than 10. e.g.: -Bt 1024.