To maintain good performance of data calculations, use the DB2 RUNSTATS utility after you first load data into a new multidimensional database and before you run your first calculation script.
The RUNSTATS utility updates statistics in the DB2 system catalog tables to help with the query optimization process. Without these statistics, the database manager might make a decision that can adversely affect the performance of an SQL statement. For more information on the RUNTSTATS utility, see the DB2 Administration Guide.