The SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system
procedure disables the log archive mode and deletes any existing online archived
log files if the DELETE_ARCHIVED_LOG_FILES input parameter
is non-zero.
See "Roll-forward recovery" in the
for more information on using
this procedure.
SyntaxSYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(IN SMALLINT DELETE_ARCHIVED_LOG_FILES) No
result is returned from the procedure.
- DELETE_ARCHIVED_LOG_FILES
- If the input parameter value for the DELETE_ARCHIVED_LOG_FILES parameter
is a non-zero value, then all existing online archived log files are deleted.
If the parameter value is zero, then existing online archived log files are
not deleted.
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.
JDBC exampleThe following example disables log
archive mode for the database and deletes any existing log archive files.
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(?)");
cs.setInt(1, 1);
cs.execute();
cs.close();
SQL examplesThe following example disables log
archive mode for the database and retains any existing log archive files:
CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(0);
The following example disables log archive mode for the database and deletes
any existing log archive files:
CALL SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(1);