Altering an SQL/MP alias

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, navigate to the Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand the SQL/MP Aliases folder and select the alias name you want to alter.
  4. Right-click and select Alter SQL/MP Alias.

    The Alter SQL/MP Alias dialog box appears.

  5. Select the required system name in the System drop-down.

    The SQL/MP Target navigation tree is populated with volume, subvolume, and file names based on the selected system.

  6. Select the required volume, subvolume, and file name in the SQL/MP Target navigation tree.

    The Location text box is populated with the path selected in the SQL/MP Target tree.

  7. Click OK.