(1905) Maintain Requests

In the dialog DataTiering Request Browser you may display information about the individual requests for a DataProvider (see Request information ) or perform maintaining operations such as:

• Repair a request
• Delete an offloaded request
• Reload offloaded data
• Schedule the offloading process of a DataProvider

To access requests of the particular DataProvider select Manage DP on the main screen.

Request information

The following fields display request Information:

DataProvider: Name of the selected DataProvider

Request ID: Request number. To display more information about its subrequests, click on the request number.

Logs: You can display logs for the selected offloading request ID or for its partitioning requests, if there are any.

Offloading condition: Offloading condition used for the particular request

Phase: Process phase in text form

Status: Status of a request can be:

Running – process is running

Processed – process finished successfully

Failed – error occurred during the process. In this case you may run Repair of a request.

Scheduled – Offloading is scheduled

Lines read: Number of archived records for a Request ID

Statistics
More details (user, date and time, duration of processing) about request phases and detailed processing history can be viewed under Statistics.

These are the six different phases of a request:

1. Offload Copy: Requested records are copied from a source table to a target table.
2. Offload Verify: This phase verifies if the copied records are same as the requested records.
3. Offload Delete: Requested records are deleted from the source table.
4. Reload Copy: Requested records are copied from a target table to a source table.
5. Reload Verify: This phase verifies if the copied records are same as the requested records.
6. Reload Delete: Requested records are deleted from the target table.

In Request statistics you can view a detailed history of a request processing by selecting History.

User Name: Name of the user who created the request

Start Date: Date of the request creation

Start Time: Time of the request creation

End Date: Date of the request end

End Time: Time of the request end

Display offloaded data

To view offloaded data for the selected DataProvider, select Data Browser. The functionality is similar to the standard ABAP Data Browser (SE16).

The table name consists of ZOFF prefix and the DataProvider name. However, if the DataProvider name is longer than 12 characters, the respective target table name is generated as shown on the figure.

Repair a request

To repair the request click on in the column Activity and the repair process reruns the request.

Delete an offloaded request

If an offloaded request fails in the Offload-Copy or Offload-Verify phase and you don't want to repair the request, you may delete it by clicking Delete.

Reload an offloaded request

By clicking in the column Activity, you can schedule the reload process for a particular offloaded request.

You may reload all offloaded requests of a DataProvider by selecting Reload All.

Schedule the offloading process of a DataProvider

You can schedule an offloading process for the selected DataProvider by selecting Schedule DP.

You can schedule an offloading job to start immediately, at a specific date and time or after a job or an event.