Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


CREATE SHADOW


Creates a new shadow for a databank.

Usage

Embedded/Interactive/ODBC/JDBC.

Description

A new shadow for a databank is created, i.e. a new physical file is created in the host file system and the contents of an existing Mimer SQL databank is copied to the file, see the Mimer SQL Systmen Management Handbook, chapter 9, Mimer SQL Shadowing, for more details.

The filename-string specifies the name of the new file in the host system and is stored in the data dictionary as the physical location of the shadow.

Restrictions

CREATE SHADOW is only for use with the optional Mimer SQL Shadowing module.

The ident executing the CREATE SHADOW statement must hold SHADOW privilege.

The CREATE SHADOW statement cannot be used if the databank to be shadowed is OFFLINE.

The databank to be shadowed (specified by databank-name) cannot be used by any other user while the shadow is being created.

A databank must have either the TRANS or LOG option if it is to be shadowed, since the shadowing facility requires transaction handling.

Notes

The shadow-name may not be the same as that of any existing databank or shadow.

The value of filename-string must always be enclosed in string delimiters. The maximum length of the filename string is 256 characters.

Refer to Specifying the Location of User Databanks for details concerning the specification of path name components in filename-string.

Example

The following example creates the shadow SYSDB_S for the Mimer SQL system databank SYSDB in the file my_sysdb_s:

 CREATE SHADOW SYSDB_S 
 FOR SYSDB IN my_sysdb_s 
 

For more information, see the Mimer SQL Systmen Management Handbook, chapter 9, Mimer SQL Shadowing.

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
MIMER EXTENSION
The CREATE SHADOW statement is a Mimer SQL extension.
Note: Databank shadowing does not affect application portability in any way because its runtime operation is completely transparent.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX