Estimating Calculation Affects on Database Size

Given the current number of blocks in a database, you can estimate the number of blocks that a CALC ALL will produce.

  To estimate the database size resulting from a calculation using interactive mode:

  1. Load data and issue a CALC ALL command and note the average block size.

  2. Start the MaxL shell, log on to Essbase, and start an application and database. For example:

    essmsh 
    login username password;
    alter system load application appname;
    alter application appname load database dbname;
  3. Providing the application and database name, enter the following MaxL statement and note the value that is returned for the number of blocks:

    query database appname.dbname get estimated size;
  4. Multiply the number of blocks by the average size of the blocks in the database.

    Results are accurate to ±10%.

Be aware of the following conditions when you query Essbase for an estimate of the full size of a database: