Database settings

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

Users with read-only permissions can only view but not modify the database settings.

  1. Navigate to System > System settings > Database, retention and reporting > Database settings.
    The Database dialog box is displayed.
  2. The system displays the database version (read-only).
  3. To maintain an audit log in the database, select Write to audit log. (Default: Selected)

    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.

  4. When a job completes (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. Select either option for Archive mode:
    • Automatic: A periodic system task archives the job details from the live to finished tables.

    • Manual: Archives the finished jobs when you click the Archive finished jobs link, otherwise the jobs remain in the live jobs table. See Archive finished jobs.

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

  5. Click Save.

    The configured settings are saved.

    Note Restart the TotalAgility IIS Application Pool, TotalAgility Core Worker Service and TotalAgility Streaming Service for the updated settings to take effect.