Fujitsu UDS/SQL V2.5 5.7 Formulas for calculating the storage space requirements for records and tables

SSL Calculation formulas
U929-J-Z125-9-76 177
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 24. Oktober 2007 Stand 08:58.55 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k05
5.7 Formulas for calculating the storage space requirements for
records and tables
The storage space requirement for records varies depending on whether they are stored in
a direct hash area, whether an indirect hash area is set up for them and which type of
connection has been specified for them. table 10 and table 11 contain formulas to calculate
the storage space requirement. These formulas differ, depending on whether the page
length of the database is 2048 bytes, 4000 bytes or 8096 bytes.
Calculation formulas for a database with a 2048-byte page length
Number of records
in the data page 2028

record length1+8
in the direct CALC page 2018

record length+key length+15
Number of entries in the indirect CALC page 2018

key length+7
Number of table
entries per page in a:
List 2002

key length+8
pointer array 2
sort key table 3
SEARCH key table
(TYPE IS REPEATED-KEY)
2002

key length+7
Table 10:Calculation formulas for a database with a 2048-byte page length