See "Using the backup procedures to perform an online backup" in the
for more information on using
this procedure.
Syntax SYSCS_UTIL.SYSCS_BACKUP_DATABASE(IN BACKUPDIR VARCHAR()) No
result is returned from the procedure.
- BACKUPDIR
- An input argument of type VARCHAR(32672) that specifies the path to a
directory, where the backup should be stored. Relative paths are resolved
based on the current user directory, user.dir, of the
JVM where the database backup is occurring. Relative paths are not resolved
based on the derby home directory. To avoid confusion, use the absolute path.
Execute privileges
If authentication and SQL authorization are both enabled, only the
database owner has
execute privileges on this procedure by default. See "Configuring user
authentication" and "Configuring user authorization" in the
for more information. The
database owner can grant access to other users.
JDBC example The following example backs up the
database to the c:/backupdir directory:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)");
cs.setString(1, "c:/backupdir");
cs.execute();
cs.close();
SQL example The following example backs up the
database to the c:/backupdir directory:
CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('c:/backupdir');