Calculate Space Requirements for Heap Tables
Use the following procedure to determine the amount of space needed to store the data in a heap table:
1. Create the table.
2. Determine the number of rows that fit on a page.
select tups_per_page from iitables where table_name = ‘tablename’;
3. Determine the total number of pages needed if the table is a heap.
total_heap_pages = num_rows / tups_per_page