Kbase P4476: Binary load performance problem using the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
SYMPTOM(s):
Binary load performance problem using the "build indexes" parameter.
Using the "build indexes" option with the binary load.
Process seems to stall at truncating the bi file message.
The BI file is being automatically truncated. (1526)
CAUSE:
Not using the "-G 0" parameter with the binary load "build indexes" parameter.
FIX:
Upon using the "build indexes" option within a 9.1x binary load operation Progress needs to truncate the DB's BI file. To minimize the amount of time involved in the binary load operation use the "-G 0" parameter to immediately begin the BI file truncation
Example: proutil Dbname -C load tablename.bd build indexes -G 0