Deleting Operational Data

As an Automic Automation administrator, you have several key responsibilities regarding database maintenance. These include unloading - and therefore deleting - operational data and the corresponding reports from the AE database.

Important! Follow the database maintenance workflow described here: Database Maintenance Flow.

Prerequisites and Recommendations for Deleting Operational Data

Make sure that you meet the prerequisites and consider the recommendations listed below:

• You must first configure the reorganization parameters in the UC_UTILITY_DB_UNLOAD variable that is available in Client 0 in which case, it affects the whole system. You can also create and define the variable in a production Client and define it only for said Client. For more information, see UC_UTILITY_DB_UNLOAD - Executed Reorganization Runs.

• The no_archive_check= parameters defined in the INI file of the AE DB Unload Utility now must be defined in the UC_UTILITY_UNLOAD variable using the NO_ARCHIVE_CHECK key.

• You need the Database Maintenance (DB_MAINTENANCE) privilege to reorganize data. For more information, see Granting Automation Engine Privileges.

How to Delete Operational Data

You can delete your operational data using the following methods:

• Through AWI, see Deleting Operational Data through AWI below.

• Through the REST API using the endpoint that facilitates triggering data deletion, see AE REST API - Database Maintenance.

• Using the AE DB Unload Utility, see AE DB Unload.

Deleting Operational Data through AWI

You trigger the data deletion process from the list of Clients, either in Client 0 or in a production Client. As soon as a deletion run starts, an entry is written to the Client History list displaying its runID, its status and additional information such as name, type (which is always CLNTDBDL for deletion operations), and so forth.

To run the Delete Data function

1. Go to the Administration perspective and open the list of Clients.

2. Select the Client whose operational data you want to delete. If you are working in a production Client, this list contains only one entry. In Client 0, the list contains multiple entries from which you can select more than one Client to delete data.

3. Right-click and select Database Maintenance > Delete Operational Data.

   The Start Deleting dialog is displayed that shows you either the Client or number of Clients for which you want to unload data and prompts you to confirm your action.

4. You can see the deletion run listed on the Client History page. For more information, see Monitoring the Client History.

   Note: You can also Cancel the unloading from the Client History page. In this case, the data that was already deleted until the run was stopped is deleted permanently. The report displays the status up to the run being stopped.

To Cancel the Data Deletion

1. Go to the Administration perspective and open the list of Client History page.

2. Select the relevant deletion run or runs (CLNTDBDL) from the list.

3. Right-click and select Cancel Deleting Data. A dialog is displayed that prompts you to confirm that you want to cancel the data unloading run.

Deleting Operational Data Using the AE REST API

You use the REST API to delete operational data in on-premises, AAKE and Automic SaaS environments.

For more information, see REST API: Deleting Operational Data.