Archivation of Request Administration Data 

Use

When you display a request in the extraction monitor or in InfoProvider administration, the system checks the completeness of the administration tables of the scheduler and log tables of the extraction monitors (tables RS*DONE and RSMON*). If the entries for the request are not complete or are missing in the table, the system gives this request the status red. Since the system uses the administration data to dynamically determine the request status, this administration data is required. If the system gives a request the status red because it cannot find the administration or log information, the technical and QM status is reset in all the targets that are filled by this request. This may result in a termination, or in the queries that are defined for the affected InfoProviders displaying obsolete data, or no data at all. Therefore, you cannot delete entries from these tables.

The administration tables in the scheduler and the log tables in the extraction monitor increase with each new request from BI. This in turn affects performance.

Archiving request administration data allows you to store the administration and log information for a request in an archive. In BI, tables store the totals records that the system requires so that the request is not set to red because information is missing. This function allows you to limit the size of the administration and log tables, RS*DONE und RSMON*. This improves performance for actions performed for the request and in the affected InfoProviders and saves memory space in the database without affecting the status set by the system.

For certain functions and processes that access requests, you have to reload request administration data to the BI administration and log tables.

Reloading Request Administration Data

Integration

The archiving concept for request administration data is based on the SAP NetWeaver data archiving concept. The archiving object BWREQARCH contains information about which database tables are used for archiving, and which programs you can run (write program, delete program, reload program). You execute these programs in transaction SARA (archive administration for an archiving object).

In addition, you can manage archiving sessions for requests in archive management in the Administration functional area of the Data Warehousing Workbench. You can execute various functions for the archiving sessions here.

Prerequisites

Reports RSSTATMAN_CHECK_CONVERT_DTA and RSSTATMAN_CHECK_CONVERT_PSA have been executed at least once for all objects. We recommend that you execute reports in the background.

Features

Overview of Archived Tables

Request data is archived from the following tables:

Table	Changes upon Archiving
RSSELDONE	One record for each archived request remains in the table
RSLDTDONE	Entries for the selected request are deleted during archiving
RSDELDONE	Entries for the selected request are deleted during archiving
RSHIEDONE	Entries for the selected request are deleted during archiving
RSRULEDONE	Entries for the selected request are deleted during archiving
RSMONMESS	Entries for the selected request are deleted during archiving
RSMONFACT	Entries for the selected request are deleted during archiving
RSUICDONE	Entries for the selected request are deleted during archiving
RSTCPDONE	Entries for the selected request are deleted during archiving
RSMONICTAB	Entries for the selected request are deleted during archiving
RSMONIPTAB	Entries for the selected request are deleted during archiving

Table RSREQDONE, the header table of the request, contains one record for each archived request with information about the archiving status.

The content of tables RSMONRQTAB and RSCRTDONE are not archived.

Functions in archive administration for archiving object BWREQARCH (transaction SARA):

Here you can:

●      Execute the write program for archiving request administration data.

●      Execute the program for deleting archived administration data belonging to the requests from the database table.

●      Display an overview of the archiving session.

●      Execute the program for reloading archived request administration data of a complete archiving session into the database table.

Functions in archive administration of requests in BI (transaction RSREQARCH)

Here the system displays the archiving sessions for archiving object BWREQARCH. Here you can:

●      Go to the archive administration for the archiving object BWREQARCH (transaction SARA).

●      Display requests with archived administration data for an archiving session.

●      Display the selections for an archiving session.

●      Reorganize archiving sessions.

●      Compare archiving sessions.

●      Delete archiving sessions from archive administration in BI if they no longer contain administration data for the request.

●      Reload archived administration data for individual requests back into the database tables.

Constraints

It is currently not possible to archive request administration data for data transfer processes.

Recommendations

To avoid reloading data from the archive unnecessarily, we recommend that you only archive request administration data for requests that are more than three months old and will probably not be edited again.