SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system procedure
The SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system
procedure unfreezes a database after backup.
SyntaxSYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()
No
result set is returned by this procedure.
ExampleString backupdirectory = "c:/mybackups/" + JCalendar.getToday();
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_FREEZE_DATABASE()");
cs.execute();
cs.close();
// user supplied code to take full backup of "backupdirectory"
// now unfreeze the database once backup has completed:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE()");
cs.execute();
cs.close();