Opdateret: 01-10-2024
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 inlogs
and theCurrent_use_log_0, …, current_use_log_<logs>
are created. If set tofalse
, the previous number of log files that was set inlogs
is used, otherwise the new number as set in<logs>
is used.Note: Thefalse
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.