When writing, deleting, reading, or reloading, statistical data on each archiving run (such as the storage space that has been freed in the database by deletions or the number of deleted data objects) is automatically generated and is persistently stored in the database The data archiving administrators can analyze these figures so that they can better plan future archiving projects and request the necessary resources. Statistics also provided pertinent information on the role of data archiving in reducing the data volume in the database.
The statistics are collected by the Archive Development Kit (ADK). This occurs during the write, deleted, and reload processes. In other archiving contexts, such preprocessing, postprocessing or conversion programs, no statistics are collected.
You can call the analysis transaction, either directly from the initial screen of Archive Administration (transaction
SARA
), or from the management part of Archive Administration: To do so, choose
Statistics
. Alternatively, you can use transaction
SAR_DA_STAT_ANALYSIS.
In addition to the analysis transaction, in which the statistics can be directly displayed, the statistics are also sent to the standard log for the write, delete, read and reload programs, from where they can also be analyzed. As a prerequisite, the relevant application must call the standard log. The standard log can be run in both test mode and production mode in the write program only. In all other programs it can be run in production mode only. In other archiving contexts, such preprocessing, postprocessing or conversion programs, no standard log is issued.
Selection
The statistical information is displayed on the basis of the selection data entered here. Selection data includes the
client
in which the archiving session was run, the name of the
archiving object
, the
date
on which the archiving session data was run, and the
status
of the archiving session. Multiple selection is also possible.
Archiving Session Number
When selecting the archiving sessions for reporting, you can choose between archiving sessions with the following statuses:
Incomplete
Complete
Replaced
To select a status, enter the corresponding code. You can mark one indicator, or a combination of several.
The status used here is the same as the archiving status in the management part of Archive Administration. For more information, see Details on the Archiving Session .
Displaying Statistical Information
To display statistical information, choose
Display Statistics
.
The display uses the SAP List Viewer functions (formerly the ABAP List Viewer
ALV
). For a general description of the comprehensive functions of the SAP List Viewer and how to use this tool, see
SAP List Viewer (ALV) Grid Control (BC-SRV-ALV)
.
Note
To make settings that affect how the statistics are displayed, choose
Select Layout
. Here, you can, for example, set the column width, the column sequence, or column selection and then save the changed display as a user-specific layout variant. For a display that is easier to use, you can also hide columns that do not interest you.
In the full display (that is, if a user-layout has not been defined), the following information is displayed:
Column |
Notes |
Archiving Session number |
Archiving session number |
Object |
Archiving object name |
Client |
Client in which the archiving session was carried out |
Date |
Date on which the archiving session was carried out |
Status |
Status of the session number
|
Disk Space |
Space on the (hard) disk occupied by the archiving session |
Header data |
Proportion of header data in the archiving session. In addition to the actual data, an archive file also contains header data that classifies and describes the business data. An archiving session’s header data should be as small as possible. |
DB Space (Write) |
"Virtual" storage space in MB that is occupied by an incomplete archiving session in the database |
|
Occupied table storage spec in the database in MB; |
|
Occupied index storage space in the database in MB, storage space category "Indexes" in the column DB Space (Write) |
|
Occupied cluster storage space in the database in MB, storage space category "Cluster" in the column DB Space (Write) |
|
Occupied structure storage space in the database in MB, storage space category "Structures" in the column DB Space (Write) |
DB Storage Space (Delete) |
"Virtual" storage space in MB that is occupied by an incomplete archiving session in the database |
|
Deleted table storage space in the database in MB. Storage space category "
|
|
Deleted table storage space in the database in MB. Storage space category "Tables
|
|
Deleted cluster storage space in the database in MB, storage space category "Cluster" in the column
|
|
Deleted structure storage space in the database in MB. Storage space category "Structures
|
DB Space (Reload) |
"Virtual" storage space in MB that is occupied by a reloaded archiving session in the database |
|
Reloaded table storage space in the database in MB. Storage space category "Tables" in the column
|
|
Reloaded index storage space in the database in MB. Storage space category "Indexes" in the column
|
|
Reloaded cluster storage space in the database in MB, storage space category "Cluster" in the column
|
|
Reloaded structure storage space in the database in MB. Storage space category "Structures" in the column
|
Written Data Objects |
Number of data objects that were written to an incomplete archiving session |
Deleted Data Objects |
Number of data objects that were deleted for an complete archiving session in the database |
Reloaded Data Objects |
Number of data objects that were reloaded for a replaced archiving session in the database |
Number of delete jobs |
Number of delete jobs that have run for an archiving session |
Write job duration |
Duration of a write job for an archiving session in hours |
Delete job duration |
Average duration of an archiving session in hours |
Reload job duration |
Duration of a reload job for an archiving session in hours |
Caution
To calculate database storage space, the system uses the length of the relevant object types as defined in the ABAP Dictionary. The value that is determined in this way can therefore only be seen as an approximation for the actual storage space in the database.
For more information on the calculation of database storage space and the storage space categories, see How Is Database Storage Space Calculated? .
Archiving Statistical Information
Statistical information is stored persistently in database table ADMI_STATS and can be archived together with the Archive Administration data using archiving object BC_ARCHIVE. For more information on BC_ARCHIVE, see Archiving Administration (BC-CCM-ADK) .