SYSCS_UTIL.SYSCS_BACKUP_DATABASE

The SYSCS_UTIL.SYSCS_BACKUP_DATABASE system procedure backs up the database to a specified backup directory.

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 full system path to the database directory to be backed up.

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');