Skip to main content

Trim Archive History (Data Management Tools)

Summary

Deletes retired archive records from nonversioned archive-enabled datasets.

Over time, the archive history of a table can increase exponentially as the edit history is maintained. This can affect storage and backup management decisions and may affect performance if the data becomes too large for the system in place. Some organizations may use nonversioned archiving because it is required for certain functionality and have no need for historical records, or they may want to remove older data that is no longer relevant. This tool allows you to delete all retired rows or the retired rows older than a specified date.

Learn more about trimming the archive history

Usage

  • This tool only supports datasets that are stored in an enterprise or mobile geodatabase. The following databases are supported:

    • IBM Db2

    • Microsoft SQL Server

    • Oracle

    • PostgreSQL

    • SAP HANA

  • The input table must be archive enabled.

  • The input table must be nonversioned. Versioned tables are not supported.

  • You must be connected to the geodatabase as the data owner to run this tool.

  • You can access the last trimmed date of a dataset from the feature class or table properties dialog box.

  • If the Input Table parameter value has been published as a feature service and is enabled for offline use, and the Trim Before Date parameter value is unspecified, and if any of the rows are referenced by a replica that has not synced those rows, the tool will fail. If the Trim Before Date parameter value is specified and the retired rows are referenced by a replica that has not synced those rows, you must provide an earlier Trim Before Date value or unregister the replica.

Parameters

Label Explanation Data type

Input Table

The nonversioned archive-enabled table with the archive history to be trimmed.

Table View

Trim Mode

Specifies the trim mode that will be used to trim the archive history.

Note:

At the current version of ArcGIS Pro, only the delete trim mode is available.

  • Delete—The archive records will be deleted.

String

Trim Before Date

(Optional)

Archive records older than this date and time will be deleted. The date and time must be in UTC. If no date is provided, all archive records will be deleted.

Date

Derived output

Label Explanation Data type

Output Table

The updated input table with the trimmed archive history.

Table

Environments

This tool does not use any geoprocessing environments.

Licensing information

  • Basic: No
  • Standard: Yes
  • Advanced: Yes