Examples

Example 1

Place the database in a hold status and build the manifest file using the quiesce command:

quiesce database pubs2_tag hold pubs2 for external dump to "/work2/Devices/Mpubs_file" with override

Once the command completes, control returns to the user.

Example 2

Copy the database devices.

If you do not know which devices are to be copied use the mount database with listonly to list all the devices to be copied.

1> mount database all from “/data/sybase2/mfile1” with listonly
2> go

“/data/sybase1/d0.dbs” = “1dev1”

A manifest file cannot be created if the set of databases that are quiesced contain references to databases outside of the set. You may use with override option to bypass this restriction.

quiesce database pubs2_tag release for external dump to Mpubs_file