Kbase 18992: Error 290 when doing idxbuild against large tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2004 |
|
Status: Verified
SYMPTOM(s):
Errors sorting a lot of records without indexes (100,000 or more).
Error 290 when doing idxbuild on large tables with sorting
SYSTEM ERROR: I/O error <n> in <program>, ret <n>, file <n>, addr <n>. (290)
The "file <n>" is a srt file.
Replacing <String> with Unknown Value. (2271)
CAUSE:
Default speed sort and merge parameters for idxbuild are not sufficient for sorting of large tables.
FIX:
You need to use speed sort and merge number parameters when issuing idxbuild command. Example:
proutil <dbname> -C idxbuild -TB 24 -TM 32