Compress Geodatabase

Geodatabase compression removes unnecessary states and rows from the system tables where versions and versioned edits are tracked. Only geodatabase administrators have the ability to compress a geodatabase.

This Action Handler doesn't run during version processing, but instead it simply runs at the scheduled time, separate from version processing. As a best practice, avoid scheduling this Action Handler during version processing. But, if you choose to schedule it at a date/time that overlaps with version processing, this Action Handler is designed to wait until version processing is complete before it starts its work.

To run Compress Geodatabase functionality, on the Schedule tab specify the General Start Time and ensure the Compress Geodatabase node is checked. Start GDBM service.

The process compresses the geodatabase and the status is logged in the Logging tab as shown below.

View the SDE_Compress_log table to check the status of the compression. Refer the below image.

TIP: COMPRESS_LOG table is automatically created if one doesn’t already exist.