The SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE system
procedure unfreezes a database after backup.
See "Using operating system commands with the freeze and unfreeze system
procedures to perform an online backup" in the
for more information on using
this procedure.
Syntax SYSCS_UTIL.SYSCS_UNFREEZE_DATABASE() No
result set is returned by this procedure.
Execute privileges
If authentication and SQL authorization are both enabled, only the
database owner has
execute privileges on this procedure by default. See "Enabling user
authentication" and "Setting the SQL standard authorization mode" in the
for more information. The
database owner can grant access to other users.
Example String 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();