Deleting Uncompleted Consistency Requests with SAP (SAP Library - SAP Database Guide: Informix (BC-DB-INF-DBA))

Deleting Uncompleted Consistency Requests with SAPDBA

Use

SAPDBA uses a control table to regulate data consistency checks (this table is also used for SAPDBA reorganizations). If an action from the Data Consistency menu has not successfully completed, it leaves entries in the SAPDBA control table. Use this action to delete such uncompleted requests from the control table.

Prerequisites

SAPDBA is installed correctly. Refer to SAPDBA Setup.

You know how to use SAPDBA and have logged on. Refer to Starting SAPDBA.

Delete uncompleted requests in the following circumstances:

You have started an action from the Data Consistency menu and the action has not successfully completed and any of the following conditions is true:

You do not want to use the restart processing to repeat the action
You want to start the entire process again from the beginning
You have tried the restart processing, but it has not worked for some reason

For details of restart processing, see Restarting Uncompleted Consistency Requests with SAPDBA.

You want to perform housekeeping for requests that have been left in the control table.

Procedure

Choose Reorganization ® Delete Uncompleted Requests.

SAPDBA displays a list of uncompleted requests.

Select the relevant request and delete it. You can also delete all uncompleted requests at once.

Note

Checking All Tables of R/3 Database for Data Consistency with SAPDBA generates a lot of entries in the SAPDBA control table. Therefore, delete or restart uncompleted requests from this action as soon as possible. This is especially important if you do a reorganization, because reorganizations use the same control table. Otherwise the performance of the reorganization deteriorates.