SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system procedure

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 Derby Server and Administration Guide for more information on using this procedure.

Syntax

SYSCS_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 Derby Developer's Guide for more information. The database owner can grant access to other users.

JDBC example

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

SQL examples

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