Reload the database using load database. If the original database stored objects on user-defined segments (sysusages reports a segmap greater than 7) and your new device allocations match those of the dumped database, Adaptive Server preserves the user segment mappings.
If you did not create the new device allocations to match those of the dumped database, Adaptive Server will remap segments to the available device allocations. This remapping may also mix log and data on the same physical device.
If
an additional failure occurs while a database is being loaded, Adaptive
Server does not recover the partially loaded database, and notifies
the user. You must restart the database load by repeating the load command.
