This procedure returns an error if there are any transactions in
progress that have unlogged operations at the start of the backup, instead of
waiting for those transactions to complete.
SyntaxSYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT
(IN BACKUPDIR VARCHAR(32672),
IN SMALLINT DELETE_ARCHIVED_LOG_FILES)
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.
- DELETE_ARCHIVED_LOG_FILES
- If the input parameter value for the DELETE_ARCHIVED_LOG_FILES parameter
is a non-zero value, online archived log files that were created before this
backup will be deleted. The log files are deleted only after a successful
backup.
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 exampleThe following example backs up the
database to the c:/backupdir directory and enables log archive
mode:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT(?, ?)");
cs.setString(1, "c:/backupdir");
cs.setInt(2, 0);
cs.execute();
SQL examplesThe following example backs up the
database to the c:/backupdir directory, enables log archive
mode, and does not delete any existing online archived log files:
SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT('c:/backupdir', 0)The following example backs up the database to the c:/backupdir directory
and, if this backup is successful, deletes existing online archived log files:SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT('c:/backupdir', 1)