Kbase P17845: How to make a Multi-volume database from a Single Volume database when it grows to 2 gig.
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  7/14/2009 |
|
Status: Verified
SYMPTOM(s):
Version is earlier than Progress 9.1C
bkioWrite: lseek error <error number> on file <file> at <address>, file <file-name>. (6081)
<function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset <bytes>, file <file-name>. (6091)
<function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset 2147467264, file <file-name>. (6091)
Getting error similar to <function>:Insufficient disk space during <system call>, fd <file descriptor>, len <bytes>, offset 2147467264, file <file-name>. (6091)
FACT(s) (Environment):
Progress 8.x
Progress 8.2C
All Supported Operating Systems
CAUSE:
The single volume database extent has grown to 2 gigabyte and can not extend further.
Two gigabytes is the programmed limit for file sizes of database extents in versions earlier than 9.1C.
FIX:
Step 1)
As long as the database is not damaged you must first backup the database with the Progress backup tool
probkup <dbname> <backup file | device>
This presumes the database is not running.
If you have sufficient space for a new larger copy of this database somewhere else on the system skip to step 4.
Step 2)
Verify the backup is good.
prorest <dbname> <backup file | device> -vf
If the verify operation succeeds without error delete the database
Step 3)
Remove the existing directory if you do not have space for multiple copies.
prodel <dbname>
Step 4)
Make a new structure for the database to live in.
(See Database Administration Guide for more discussion on Creating a Multi-Volume Database)
NOTE: If you have plenty of space on your drives /tmp might be replaced with any directory which has sufficient space to hold the files.
Example st file
d /tmp f 2097120
d /tmp f 2097120
d /tmp
b /tmp
end example st file
prostrct create <new db> example.st
Step 5)
prorest <new db> <backup file | device>