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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se