Creates a new shadow for a databank.
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 System Management Handbook, Mimer SQL Shadowing, for more details.
filename-stringspecifies the name of the new file in the host system and is stored in the data dictionary as the physical location of the shadow.
CREATE SHADOWis only for use with the optional Mimer SQL Shadowing module.
The ident executing the
CREATE SHADOWstatement must hold
CREATE SHADOWstatement cannot be used if the databank to be shadowed is
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
LOGoption if it is to be shadowed, since the shadowing facility requires transaction handling.
The Mimer SQL shadowing functionality cannot be used together with the automatic upgrade feature. When setting the
AUTOUPGRADEattribute on a database, following
CREATE SHADOWstatements will fail. And vice versa, when having databank shadows in the system it will not be possible to enable the
shadow-namemay not be the same as that of any existing databank or shadow.
The value of
filename-stringmust 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
The following example creates the shadow
SYSDB_Sfor the Mimer SQL system databank
SYSDBin the file
sysdb_s:CREATE SHADOW SYSDB_S FOR SYSDB IN 'sysdb_s'
For more information, see the Mimer SQL System Management Handbook, Mimer SQL Shadowing.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40