MVSFORUMS.com

[abc2000]

DB2 4074 4056

Calculating the space required for a table

the space available to store records in a 4 KB page is 4074 bytes.
Achieving that maximum in practice is not always simple. For example, if you
are using the default values, the LOAD utility leaves approximately 5 percent
of a page as free space when loading more than one record per page. Therefore,
if two records are to fit in a page, each record cannot be longer than 1934
bytes (approximately 0.95 * 4074 * 0.5). Furthermore, the page size of the
table space in which the table is defined limits the record length. If the
table space is 4 KB, the record length of each record cannot be greater than
4056 bytes. Because of the 8-byte overhead for each record, the sum of column
lengths cannot be greater than 4048 bytes (4056 minus the 8-byte overhead for a record).
(DB2 Universal Database for OS/390 and z/OS
Administration Guide
Version 7
Document Number SC26-9931-03
2.6.2.1 Calculating record lengths and pages)


4074-4056 = 18 bytes , who konow this 18 bytes detail ?

[kolusu]

abc2000,


Please SEARCH before posting. Check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=5284&highlight=tablespace

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu