Creating and Managing Shadows
There are two ways of creating and managing shadows:
- Using the SQL shadowing commands:
- 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.
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.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40