http://developer.mimer.com

Creating and Managing Shadows

---

There are two ways of creating and managing shadows:

• 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: You cannot alter shadows for the system databanks: SYSDB, TRANSDB, and LOGDB using the ALTER SHADOW command. You must alter them using the Mimer SQL UTIL program.

• Using the shadowing utilities in the Mimer SQL UTIL program. See Shadowing Utilities.

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.

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se