Is This Content Helpful?
We're glad to know this article was helpful.
Instructions provided describe how to compress a versioned database to state 0. The objective of a compress is to delete non-referenced states, combine states that share the same lineage, and move rows from the delta tables into the base tables. If the compress command does not return an error, the compress is successful. If the intention is to compress the entire instance to state 0, then additional steps must first be performed prior to executing the compress command.
If the instance has not been compressed to state 0 and there is an attempt to unregister a class as versioned, a warning message may be encountered.
The warning may occur because the delta tables of the versioned class still contain rows that have not been compressed and are still being referenced by a version.
The frequency required for compressing is dependent upon the volume of edits. There is no harm in executing compress frequently; for example, daily, and it may be beneficial. The compress command removes as many un-referenced states as possible and, if applicable, moves rows from the delta tables to the base tables. Edits that are still referenced by a version continue to reside in the delta tables.
Follow the steps below.
Compress the database using command line:
sdeversion -o compress [-N] -u sde -p sde_password -i -s