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)
Equals number of logs to use.
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.
false setting is normally used only to ensure that the number of current use log tables actually exists.
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.