Database Management through AWI and REST

As an Automic Automation administrator, maintaining the AE database is a critical administrative task. Over time, automation systems generate large volumes of data that, if unmanaged, can reduce performance and cause unnecessary growth of the database. To keep the system running efficiently, regular database maintenance is required to remove obsolete data, archive important records, and optimize database performance.

You can perform the database maintenance tasks using the following methods, depending on the type of environment you have:

  • Either through the AWI for manual, interactive administration, or through the AE REST API for automated and scriptable execution in enterprise environments. These methods do not requires access to the database and, therefore, can be used in Automic SaaS environments.

  • Using the AE Database Utilities. The Utilities require access to the AE database. For this reason, this method is only possible for on-premises environments, see Utilities Reference.

Database Maintenance Flow

Database maintenance follows a well-defined flow. Each step builds upon the previous one, ensuring that the database stays clean, efficient, and prepared for ongoing operations. The flow consists of the following actions, that you must perform in this sequence:

  1. Archiving Operational Data

    Archive operational data as the initial step to ensure they're preserved before deletion. This process usually involves setting archive flags on eligible records.

  2. Resetting the Archive Flags through AWI (if required)

    If the archiving process encounters issues, reset all archive flags to their default values and repeat the archive step, ensuring all necessary records are archived properly.

  3. Creating Revision Reports

    Generate a revision report to review which records have been modified, imported, transported, or deleted, and confirm archive actions before proceeding with further data management.

  4. Reorganizing Operational Data

    Run a reorganization operation, which marks archived records for deletion, setting deletion flags.

  5. Resetting the Reorganization Flags through AWI (if required)

    If there is an error or inconsistency, reset all deletion flags and repeat the reorganization to ensure only the appropriate records are marked for removal.

  6. Deleting Operational Data

    Use the delete operation to permanently remove flagged data records from the database, completing the maintenance cycle.

  7. Emptying the Recycle Bin

    Use this option to permanently remove the content of the Recycle Bin.

See also: