Kbase 21673: Variable extent hits the 2 GB limit and 9.1C Database shuts down.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Error when restarting a crashed database.
Unable to extend data files enough to proceed. (6743)
SYSTEM ERROR: Attempted to exceed maximum size on file <pname>. (9452)
CAUSE:
The extent referenced in the error message is the variable extent. The database has attempted to extend beyond the 2GB limit.
FIX:
A new feature was implemented in the Version 9.1C Enterprise Database product to enable database extents to be larger than 2GB. This also requires the underlying Operating System to support large files.
The command is:
"proutil db-name -C EnableLargeFiles"
Steps to follow to bring the Database back online:
* BACKUP THE DATABASE BEFORE GOING ANY FURTHER!!!
* Be sure the database is shutdown.
* Run the command: proutil db-name -C EnableLargeFiles
* Add at least 1 fixed and 1 variable extent using the "prostrct add" utility.
* Start the database