Part 3: Total Required Versions

Calculate the total number of required versions to calculate the row count. Suppose that concurrently there are 4 budgets and 4 forecasts in the system and they all undergo the solicitation process simultaneously.

To calculate the total number of versions:

  1. Calculate the number of base Master/Sysforecast versions:

    = number of budget Master versions

    + number of forecast Master versions

    + number of Sysforecast versions

    = 4 + 4 + 4

    = 12

  2. Calculate the number of solicitation versions, based on Part 1: Copies for Budget Solicitation and Part 2: Copies for Forecast Solicitation:

    = (number of budgets currently in the solicitation process x number of solicitation copies of the budget) + (number of forecasts currently in the solicitation process x number of solicitation copies of the forecasts)

    = (2 x 11) + (2 x 5)

    = 32

  3. Calculate the total number of versions, based on the previous steps:

    = base Master/Sysforecast versions + solicitation versions

    = 12 + 32

    = 44

  4. Calculate the total number of rows per version:

    = total number of locations x total number of time periods

    = 1438 x 70

    = 100660

  5. Calculate the total number of rows in the system:

    = total number of rows per version x total number of versions

    = 100660 x 44

    = 4429040 rows

  6. Use the row count and page size information to size the data tablespace to determine how many pages DB2 needs.

    Only DB2 is mentioned in this example because Oracle tablespaces auto-extend.

    There are approximately 80 rows per page in the current table, so data tablespace sizing is calculated:

    total number of pages

    = total number of rows / number of rows per page

    = 4429040 / 80

    = 55363 pages minimum for the WB_BDG32K01_REG tablespace

    If the pages are 32KB pages, this is approximately 1.7GB for the table (55363 pages /32KB).