Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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.

Privileges

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:

Tasks
Privilege
Backup
Shadow
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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX