Recovering schema

The recover schema operation allows you to revert the changes made by a failed ownership operation on a schema or to carry it through to completion.

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, select Database > My Systems > Catalog > Schemas.
  3. Right-click on the required schema and select Change Ownership > Recover Schema.

    The Recover Schema window appears.

  4. To resume or cancel the recovery operation, select Resume or Cancel.
  5. Click Ok.