Maintaining the use log

You need to make a routine for exporting or backing up the monthly use logs that are ready to be dropped. These tables have the name format TO_BE_DROPPED_USE_LOG_<YYYYMM>, for example TO_BE_DROPPED_201501.

Important: The tables may use a lot of disk space. It is therefore important to drop the tables on a regular basis.

If you make an export of the tables, it is possible to restore the logs and examine them in the WorkZone.


Restoring old logs

If you want to examine old dropped logs in WorkZone, you will have to restore the logs. You only need to restore the months you want to examine.

After restoring the logs, do as follows:

  • Rename the restored tables to their original names, that is, without the prefix TO_BE_DROPPED_.
  • Call the procedure sjp_use_log.ready_to_view, so that the system recognizes the restored logs.

If you cannot finish the examination before the transfer job is executed, you have two options to avoid that the old logs are renamed back to include the prefix TO_BE_DROPPED_:

When you have finished the examination in WorkZone Configuration Management, you may have to either start the transfer job or change the number of whole months kept in the use log back to original value.

When the transfer job is executed, the old restored logs are renamed to include the prefix TO_BE_DROPPED_USE_LOG_, and you can just drop these tables.