Hello,

The machine I'm looking at is V7R1

Database file sizes states the following;

Here is an extract for DSPFD for my file;

Is maximum key length what they are referring to? Because using it in the afore mention forumla returns;

725,680,000,000/ 12 + (0.8 * 29) = 20,615,909,090.91

Which is 5x the stated initially stated value, I was expecting the result would be less than 4.295B.

So is it genuinely the case that if you have sequenced access paths you can have more records? Or is "Maximum key length" the wrong value to use?

Many Thanks,

Ryan

The machine I'm looking at is V7R1

Database file sizes states the following;

Number of records contained in a file member | 4 294 967 294 records^{2} |

^{2}states the following;
For files with keyed sequence access paths, the maximum number of records in a member varies and can be estimated using the following formulas.

When ACCPTHSIZ(*MAX4GB) is specified, use the following formula:

10 + (.8 x key length)

When ACCPTHSIZ(*MAX1TB) is specified, use the following formula:

12 + (.8 x key length)

When ACCPTHSIZ(*MAX4GB) is specified, use the following formula:

__2,867,200,000__10 + (.8 x key length)

When ACCPTHSIZ(*MAX1TB) is specified, use the following formula:

__725,680,000,000__12 + (.8 x key length)

Code:

Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB Access path logical page size . . . . . . . : PAGESIZE *KEYLEN Maximum key length . . . . . . . . . . . . : 29 Maximum record length . . . . . . . . . . . : 168

725,680,000,000/ 12 + (0.8 * 29) = 20,615,909,090.91

Which is 5x the stated initially stated value, I was expecting the result would be less than 4.295B.

So is it genuinely the case that if you have sequenced access paths you can have more records? Or is "Maximum key length" the wrong value to use?

Many Thanks,

Ryan

## Comment