Kbase P26795: Getting error 9452 with ai extent using " v " parameter in .st file.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/01/2009 |
|
Status: Verified
SYMPTOM(s):
SYSTEM ERROR: Attempted to exceed maximum size on file <pname>. (9452)
SYSTEM ERROR: Attempted to exceed maximum size on file a1. (9452)
There are two ai files in the .st file.
format of ai extents in .st file is:
a1 v 9465
a2
FACT(s) (Environment):
Caldera Open UNIX/SCO UnixWare
SCO OpenServer
Linux Intel
Progress 9.1C
Progress 9.1D
CAUSE:
Progress does not support Large files on the Caldera Open UNIX/SCO UnixWare, SCO OpenServer or Linux Intel platforms.
FIX:
When large file support was enabled in 9.1C the "v" extent argument was
introduced and was to be used when large files were enabled. It was intended to
prevent variable length extents from growing to undesirable sizes and to allow the dba to set the size that a variable extent could grow to. However, larger files must be enabled for Progress in order to use this variable.
ie. If there were 100 GB of disk space a variable ai or database extent could in fact become 100 GB in size.
To correct the problem of "Attempted to exceed maximum size" in this case, use the proper argument of an "f" to create an extent of a fixed size.
example:
#
a . f 9465
#
a .
#
b .
#
d "Schema Area":6,32 .
#
d "Employee":7,32 . f 320
d "Employee":7,32 .