Kbase 20456: PROSTRCT builddb Returns 9099 Error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2011 |
|
Status: Verified
SYMPTOM(s):
Error when issueing PROSTRCT builddb command to recreate .DB file.
The maximum Area Size has been reached for Area: <area-name>
Please refer to the Progress Database Limit chapter in the
Database Administration Guide and Reference. (9099)
FACT(s) (Environment):
Progress 9.1x
CAUSE:
The error occurs when the maximum number of records that can be stored in the area (calculated as records per block times blocks per area) exceeds 2 GB.
FIX:
The workaround is to use the -blocksize parameter as follows:
prostrct builddb yourdb -blocksize <block>
where <block> is 1024, 2048, 4096 or 8192 (default is 1024).
For example, the structure file below causes the (9099) error because the number of records in the "Daily Summaries" area exceeds 2 GB (128 records/block * 512000 blocks/extent * 50 extents = 3,276,800,000 records).
When the -blocksize 8192 parameter is used, the number of blocks is decreased by a factor of eight, making the total number of records in the area within the limits (128 records/block * 64000 blocks/extent * 50 extents = 409,600,000 records).
The -blocksize parameter is documented in the Release Notes
For Progress Version 9.1B (RN#: 091B-00213).
b ./test.b1
#
d "Schema Area":6,64 ./test.d1
#
a ./test.a1
#
d "Daily Summaries":43,128 ./test_43.d1 f 512000
d "Daily Summaries":43,128 ./test_43.d2 f 512000
.
(additional extents omitted for clarity)
.
d "Daily Summaries":43,128 ./test_43.d51