Overview

The key benefits of the mount and unmount commands are:

  1. The copy operation provided by the quiesce and mount commands enables you to package proprietary databases more easily; for example, data files instead of SQL scripts. The associated actions necessary for running these SQL scripts, such as device and database setup, are eliminated.

  2. The quiesce database extension for mount allows you to copy databases without a shutdown of the Adaptive Server. The primary Adaptive Server is the source, and the secondary Adaptive Server is the destination. quiesce database also allows a single secondary Adaption Server to act as standby for databases from multiple primaries, since databases from multiple sources can be copied to a single destination.

The mount and unmount commands support two operations:

With the mount and unmount commands:

  1. Remove a database using unmount, which removes a database and its devices from a server. A manifest file is created for the database that you are unmounting at a location you specify in the command clauses. The manifest file contains information pertinent to the database at the source Adaptive Server, such as database devices, server information, and database information. For more information see “Manifest file”.

  2. Copy or move the database onto the destination Adaptive Server, then use mount to add the devices, attributes, and so on for the database.

  3. Use database online to bring the database up on the destination Adaptive Server without restarting the server.

WARNING!  For every login that is allowed access to a database on the original Adaptive Server, a corresponding login for the same suid must exist at the destination Adaptive Server.

For permissions to remain unchanged, the login maps at the destination Adaptive Server must be identical to those on the source Adaptive Server.