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.
SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(IN SMALLINT DELETE_ARCHIVED_LOG_FILES)
No result is returned from the procedure.
The 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();
The 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);