5.9 Estimating the size of the work table DB area
Use the following formula to determine the size of the work table DB area.
- Formula (kilobytes)
-
work table DB area size = WRK_PAGE_NUM × page_size ÷ 1,024
Explanation of variables
- WRK_PAGE_NUM: Total number of pages in the work table DB area
-
Determine the value as explained in 5.9.1 Determining the total number of pages in the work table DB area.
- page_size: Page size in the work table DB area
-
Substitute the value specified for the initialization option adb_init_wrk_page_size determined in 5.7 Designing a work table DB area.
Note that the adb_init_wrk_page_size option is specified in kilobytes, while the page_size variable is specified in bytes.
For details about the initialization option adb_init_wrk_page_size, see adbinit (Initialize the Database) in the manual HADB Command Reference.