Set up the use log

Before you set up the use log, you need to decide:

  • The number of current use log tables to use. The default is 4.
  • The number of months kept in the use log. The default is 6.
  • When to execute the transfer job. By default, it runs 5 minutes after midnight every night.

Number of current use log tables

The number of current use log tables is set by a procedure call:

Sjp_use_log.create_current_use_logs(logs in number default 4, force in boolean default true)

  • Logs: Equals number of logs to use.
  • Force: If set to true, the number of logs is set to the number of logs specified in logs and the Current_use_log_0, …, current_use_log_<logs> are created. If set to false, the previous number of log files that was set in logs is used, otherwise the new number as set in <logs> is used.
    Note: The false setting is normally used only to ensure that the number of current use log tables actually exists.


Number of months kept in the use log

The default number of months is 6 months. You can change this in scansql using the Sjbase, Transaction log menu.

The monthly logs that you do not want to keep are not dropped or deleted, they are renamed to "TO_BE_DROPPED_USE_LOG_<YYYYMM>”. This way you can make an export/backup of the monthly log before you actually drop the table.

When to execute the transfer job

By default the transfer job is executed 5 minutes after midnight every night. You can change the time in scansql using the Sjbase, Transaction log menu.