If there are any transactions in progress with unlogged operations
at the start of the backup, the SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT system
procedure returns an error immediately, instead of waiting for those transactions
to complete.
SyntaxSYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT(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.
JDBC exampleThe following example backs up the
database to the c:/backupdir directory:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT(?)");
cs.setString(1, "c:/backupdir");
cs.execute();
cs.close();
SQL exampleThe following example backs up the database
to the c:/backupdir directory:
CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT('c:/backupdir');