Frequently asked question

Can I compress a geodatabase while users are connected?

Last Published: April 25, 2020

Answer

ArcGIS 9.0 and later releases allow an ArcSDE geodatabase to be compressed while users are connected.

Note:
This functionality is not available in ArcSDE for DB2 until the 9.2 release.


Prior to ArcGIS 9.0, when a database administrator needed to compress an ArcSDE instance, all users had to disconnect. This was required because the compress operation required an exclusive lock on the entire state tree. The exclusive lock prevented any current or future connections until the compress operation completed.

With ArcGIS 9.0 and later releases, users can remain connected during a compress operation. Therefore, users can continue performing spatial operations, editing, and cartographic output. This allows organizations to keep their ArcSDE geodatabase in production during the compress operation, eliminating unnecessary down time.

Article ID:000006856

Software:
  • ArcMap 9 x
  • Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic