This section describes how to improve performance and space usage by changing DB2 settings.
You can change the settings using utilities or commands that are supplied with DB2. The settings that you choose depend on the size of your relational cube, the number of users who will access the cube, and the expected loads for activities such as recalculating and querying the cube.
Table 9 shows some of the parameters that you need to change.
These new parameter values work well with the sample applications that are
included with DB2 OLAP Server.
Table 9. DB2 parameters to modify
| Parameter Name | New Parameter Value |
|---|---|
| LOGBUFSZ | 16 |
| BUFFPAGE | 1000 |
| LOCKTIMEOUT | 10 (seconds) |
| LOGFILSIZ | 1000 |
| LOGSECOND | 100 |
You should also use a DMS (database-managed space) table space instead of an SMS (system-managed space) table space for better performance. For more information about table spaces, see Using Table Spaces.