› System › System settings › Database, retention and reporting › Database settings

Database settings

You can view and configure the database settings if you have sufficient access permissions.

Database version
The system displays the database version (read-only).
Write to audit log
Maintains an audit log in the database.

While audit logging can be useful for monitoring server activity and performance, the audit data can increase the TotalAgility database significantly. You can clear this setting to reduce the database size and increase performance. However, if you do wish to maintain the audit log, configure the associated retention policy to delete the old audit log entries.

Record license usage

Enables recording of license usage in the audit log.

This setting is clear by default, as keeping it selected impacts performance, so nothing is recorded in the database.

When selected, it creates the following reports:

  • Consumption of volume licenses for Transformation, Imaging Page Count, and Index Page Count for a given time span. This record is based on the category of the process for the job that recorded the license volume usage.

  • Consumption of concurrent user licenses for a specific category for a given time span. In this case, the reporting matches the user session. An entry is recorded upon logon, and that record is updated when their session is either logged off or timed out.

Archive mode
When a job is completed (either through natural completion or through termination), it can be archived automatically or manually, with job details from the live tables to the finished tables to improve performance.

  • Automatic (default): A periodic system task archives the job details from the live to finished tables.

  • Manual: Archives the finished jobs when you click Archive finished jobs under "Utilities"; otherwise, the jobs remain in the live jobs table.

    • You can change the Archive mode from automatic to manual or vice versa. However, it may impact the performance.

    • When upgrading TotalAgility, the "Archive finished jobs" property retains the same setting that was set prior to upgrade.