Kbase P166364: Error 8897 runnig idxbuild all after a dump/load via bullk load
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/05/2010 |
|
Status: Unverified
SYMPTOM(s):
Error 8897 runnig idxbuild all after a dump/load via bullk load
SYSTEM ERROR: Unable to extend database within area <pareaName>. (8897)
SYSTEM ERROR: Unable to extend database within area Schema. (8897)
FACT(s) (Environment):
Do not have large files enabled in the Operating System
All Supported Operating Systems
Progress/OpenEdge Product Family
CHANGE:
Added lots of data to tables after bulkload but before running idxbuild
CAUSE:
Schema area has reached Operating System 2 GB limit for file size
FIX:
Choose one of the following:
A) Allow the database to extend more than it is currently allowed by Operating System limits by enabling large files and also enable large files for the database.
or
B) Allow the database to extend more than it is currently defined by.
1.) Ensure there is a valid backup of the Progress database
2.) Verify where there are available space on the file system
3.) Use the prostrct utility to add additional extents for the area referred in the 8897 error message
$ prostrct add dbname add.st