How To Fix RSRV580 - Platzverbrauch von MDC-InfoProvidern in DB2 für Linux, UNIX und Windows

RSRV580 - Overview

• Message type: E = Error

• Message class: RSRV -

• Message number: 580

• Message text: Platzverbrauch von MDC-InfoProvidern in DB2 für Linux, UNIX und Windows

Description
For InfoProviders that use multi-dimensional clustering (MDC) on DB2 for
Linux, UNIX and Windows, this test determines the percentage of
allocated disk space that is free. If the free space is more than 33%,
you should consider reclustering the InfoProvider.
An MDC table is physically organized such that data rows having the same
values in the MDC dimension columns are grouped together into separate
blocks. Every unique combination of values in the MDC dimension columns
forms a logical cell for which one or more blocks of pages may be
allocated. The number of pages in a block corresponds to the size of the
table space in which the table resides.
The test displays the following detailed information about MDC space
consumption for the F and E fact tables of InfoCubes:
Number of rows in the table
Number of MDC logical cells for which blocks have been allocated
Cardinality of the MDC dimensions
Number of allocated pages in the table
Number of empty pages in the table
Allocated space for the table in KB
Empty space for the table in KB
For each aggregate that uses MDC, the test provides the percentage of
space allocated for the aggregate that is free. If the free space is
more than 33%, you should consider disabling MDC clustering for the
aggregate.
The detailed information about MDC space consumption for DataStore
objects is provided for the table containing the active data.
The test computes the information from the latest collection of
statistics. If the database statistics are not current, the results may
be imprecise.
Repairs
This test provides no repair function.
Reclustering can be used to reduce space consumption for InfoCubes and
DataStore objects. With reclustering, MDC clustering can be disabled or
the MDC dimensions can be changed. Reclustering is invoked from the
context menu of the InfoProvider.
MDC clustering can be disabled for aggregates in the aggregate
maintenance screen by choosing <ZK>Change Partitioning</> from the
<ZK>Aggregate</> menu.

Was verursacht dieses Problem?

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE