Deleting Uncompleted Reorganization Requests with SAPDBA
Use
If a reorganization of a group of tables or a dbspace in SAPDBA for Informix was unsuccessful (that is, uncompleted), you can either delete the reorganization request or
restart it. The following are typical reasons why you might decide to delete an uncompleted request:
- 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 this has not worked for some reason.
- You want to perform housekeeping for requests that have been left in the control table.
For more information about how to proceed when a reorganization was unsuccessful, see
Reorganization Troubleshooting with SAPDBA.
Prerequisites
SAPDBA is installed correctly. Refer to
SAPDBA Setup.
- You are logged on in expert mode, that is, as user
informix
, and you have started SAPDBA. Refer to
Starting SAPDBA.
- A reorganization failed midway through and SAPDBA informed you with an error message. The reorganization request is still in the control table used by SAPDBA for reorganization.
Procedure
Choose one of the following in SAPDBA for Informix:
Delete Uncompleted Requests
Reorganization
®
Reorganize Group of Tables
®
Delete Uncompleted Requests
SAPDBA displays a list of uncompleted requests.
- Choose the relevant request and delete it. You can also delete all uncompleted requests in one go.
Result
The uncompleted request is no longer available. Note that you cannot restart a request that you have deleted.