Creating and Managing Shadows
Shadows are managed using the SQL shadowing commands:
CREATE SHADOW - creates a shadow
SET SHADOW - sets shadows on- or offline
ALTER SHADOW - swaps a shadow with its master
DROP SHADOW - drops a shadow.
Note: For shadow information, use the LIST SHADOWS command in BSQL.
If you have SHADOW or BACKUP privilege, you can list shadowing information for all databanks.
Users can always backup and restore, set shadows offline and online, and list shadowing information for any databank that they have created.
SYSADM is initially granted SHADOW and BACKUP privilege with the WITH GRANT OPTION.
The following table shows the privileges you need to work with shadows:
Create a shadow *) X Drop a shadow *) X Transform a shadow *) X List shadow info X X Backup and restore X Set shadow offline X
*) You must have exclusive use of the databank. This means that no other user can access the databank until the operation is finished.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40