Archives of the TeradataForum
Message Posted: Tue, 11 Jun 2002 @ 14:16:43 GMT
| Subj: | | Re: Question on space utilization of a database |
| |
| From: | | Jim Calvert |
Narayan:
The actual space used by the 6 rows and the space allocated to the table will almost always be very different. You must consider the
blocksize specified in your system as it will use those values to allocate space.
Look at the values for PermDBAllocUnit (and possibly PermDBSize) in the DBSControl record. You will find that your allocated space is a
multiple of PermDBAllocUnit, stated as a number of 512 byte sectors. Be sure to account for the header in each Amp and for the
miscellaneous header fields in each row.
Jim Calvert
| 
