You can use dump database and load database to move a database from one Adaptive Server to another. However, you must ensure that the device allocations on the target Adaptive Server match those on the original. Otherwise, system and user-defined segments in the new database will not match those in the original database.
To preserve device allocations when loading a database dump into a new Adaptive Server, use the same instructions as for recovering a user database from a failed device. See “Examining the space usage”.
Also, follow these general guidelines when moving system databases to different devices:
Before moving the master database, always unmirror the master device. If you do not, Adaptive Server attempts to use the old mirror device file when you start Adaptive Server with the new device.
When moving the master database, use a new device that is the same size as the original to avoid allocation errors in sysdevices.
To move the sybsecurity database, place the new database in single-user mode before loading the old data into it.
