Enabling the cube summary table refresh

To enable the cube summary table refresh service, you create the cube summary tables using the MQT advisor. When running the MQT advisor, you can customize the default generation parameters to influence the MQTs that are generated.

Before you begin

Before you begin this task, you must make sure that the data movement service has been enabled.

About this task

Note: MQTs are supported only when you are using DB2® as the IBM® Business Monitor database.
  • Generating the cube summary tables
    To enable the cube summary table refresh service, you use the MQT advisor to create and populate cube summary tables.
  • Configuring the database for the query optimizer
    After you create and populate the cube summary tables, you modify the database configuration so that the query optimizer uses the MQTs. Note that, if you used the scripts provided by IBM Business Monitor to create the database, these configuration settings have already been applied, and you can skip this task.
Parent topic: Managing the cube summary table refresh
Related concepts:
Cube summary table refresh overview
Managing data movement services
Related tasks:
Scheduling the cube summary table refresh service