Statistics for the Maintenance Processes of a
HPA Index 
Use
To get an overview of the runtimes of specific subprocesses in HPA index maintenance, you display table RSDDSTATTREX.
The system writes the runtimes of specific subprocesses to this statistics table for the following processes:
· Initial indexing (see Activating and Filling HPA Indexes)
· Rollup (see Rolling Up Data in HPA Indexes)
· Modifications after change runs (see System Response Upon Changes to Data: HPA Index)
Features
The statistics table contains the following information for each table that is indexed:
RSDDSTATTREX
Column |
Description |
STATUID |
Unique identification key |
TABLNM |
Table name |
CHANGEMODE |
Specifies whether the process is part of a HPA rebuild (“N”), the rollup (“R”) or a modification after a change run (“C”). |
FILLMODE |
Fill Mode: Full (“F“), delta (“D“) or change run (”C“) |
TIMEACTIVATE |
Time of activation |
TIMEREAD |
Time at which data is read from the database |
TIMEFILL |
Time at which data is packed and indexed |
TIMEOPTIMIZE |
Time of Prepare Optimize |
TIMECOMMIT |
Time of Commit Optimize |
REC_INSERTED |
Number of indexed records |
TSTPNM |
Users |
TIMESTMP |
Start time stamp |