Unmounting an Adaptive Server Database

Unmount a database from an Adaptive Server.

When you unmount a database, you remove the database and its devices from an Adaptive Server. The unmount command shuts down the database. All tasks using the database are terminated. The database and its pages are not altered and remain on the operating system devices.

In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
Click User Databases.
Click the Name field of the database to unmount, and select Unmount.
You see the Unmount Database Wizard.
Specify the location where Adaptive Server will create the manifest file.
Select Yes on the Evaluate Dependencies screen to view any unselected databases that must be selected for the unmount command to succeed.

Note: The unmount command fails unless you select all the databases on a device.
Select the databases listed in the Dependency Matrix screen for unmount to succeed. If no databases are listed in the Unselected Databases column, there are no dependencies.
Override referential integrity checks by selecting With override.

Note: When the referencing database is dropped by the unmount command with an override, you cannot drop the referential constraints.
Enter a delay for distributed or multi-database transactions in prepared state to complete before the unmount command is activated. If the transactions do not complete in the specified time period, Adaptive Server does not execute the unmount command.
(Optional) Click Summary to view your selected options.