Kbase P2490: Recovering from Errors 8897 and 8898 on a Data Extent
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/04/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Errors while attempting to update database.
SYSTEM ERROR: Attempted to exceed 2GB limit with file <pname>. (8898)
SYSTEM ERROR: Unable to extend database within area <pareaName>. (8897)
Database can be restarted and crash recovery can take place.
Error 8898 refers to a data extent.
Database shuts down abnormally.
CAUSE:
Error 8898 occurs when the database attempted to exceed the 2GB limit for the specified extent. The 8897 error specifies the area in which the extent is located. On receiving the 8897 and 8898 the database will shut down abnormally.
The explanation for error (8897) says:
"Either the database area is composed entirely of fixed-length extents that have become filled up, or the file system that contains the database is out of space. In either case the PROGRESS run is aborted and recovery must be run. If the database is fixed length, use the prostrct utility to add additional space. Otherwise, delete files from the file system to make more space available."
FIX:
1) Back up the database.
2) Create an add.st file that contains additional extents and use the prostrct add command to to add the required extent ( indicated in the 8898 error). The extent must be located in the same area as indicated in the 8897 message.
Syntax> prostrct add dbname add.st