In the UDB ESE (v8.2) Administration Guide: Planning, there's a section in Chapter 5: Physical database design which discusses space requirements for user data. On p. 75 of the pdf's hardcopy near the bottom of the pages it states:
The number of 4 KB pages for each user table in the database can be estimated by calculating:
ROUND DOWN(4028/(average row size + 10)) = records_per_page
and then inserting the result into:
(number_of_records/records_per_page) * 1.1 = number_of_pages .
My question is if I determine that the tables shold be placed in a 16K pagesize tablespace, what should I use instead of 4028?
I am trying to estimate the number of 16K pages required for a fact table and then evenly spread out the number of pages per tablespace container.
Much obliged,
Ruby