5.9.1 Determining the total number of pages in the work table DB area

Use the following formula to determine the total number of pages in the work table DB area (variable WRK_PAGE_NUM).

Formula

Explanation of variables

dbarea_file_num

Number of work table DB area files (files)

Assign 1 to the dbarea_file_num variable because there is only one work table DB area file.

tbl_num

Total number of work tables to be created at the same time (tables)

WP(i)

Number of pages required for work tables that will store base rows

For details about the variable WP(i), see 5.9.2 Determining the number of pages for base rows that are needed for storing work tables.

To Page Top