
Chapter 7. Administration of SAP BW 215
Figure 7-19 The DBA Action Log
7.3.4 Tablespace reorganization
How the stored data are physically distributed has a significant impact on the
performance of SAP BW. To maintain performance levels, this distribution of
data needs to be monitored, and, if necessary, reorganized. In this section we
discuss the options available for reorganizing the DB2 tablespaces.
Starting with testing and production, the following are examples of operations
that may affect the physical distribution of data:
Deleting data may leave empty pages.
Inserts of new data may be written to different physical storage elements.