How to access ArcGIS Data Store Full Vacuum Command?

RyanUthoff

I was reading through the ArcGIS Enterprise 11.4 issues addressed document here and saw there was an ArcGIS Data Store enhancement (ENH-000147259) that added a command line utility to perform a full vacuum.

However, when searching through Esri's ArcGIS Data Store utility reference documentation, it does not reference any vacuum command line utility. Esri's "what's new" documentation also does not reference the vacuum command line utility.

Does anyone know how to access this command line utility? Or any documentation from Esri on how to use it?

Sarah_Hanson

Hi @RyanUthoff

I can help shed some light on this one. The utility (maintaindatastore) shipped with ArcGIS Data Store 11.4, but there was an issue with getting it properly documented. This will be fixed with the 11.5 release, but I can share some information in the meantime here.

The maintaindatastore utility can be used with the relational data store or the object store. When it is run, it has the potential to reclaim disk space.

For the relational data store, it frees up disk space by cleaning up any obsolete rows left behind during heavy edit operations against hosted feature layers.

For the object store, it deletes expired feature query caches on demand rather than waiting to delete them when scheduled by the administrator. Note: when the utility is used with the object store, it restarts the object store as this is necessary to reclaim the disk space.

Here is the syntax that can be used to run the utility at ArcGIS Enterprise 11.4 (run it on the primary data store machine if your system is highly available):

Syntax
maintaindatastore --store {relational | object} [--prompt {yes|no}]

I hope this information is useful, and I appreciate you asking the question!

View solution in original post

Sarah_Hanson

Hi @RyanUthoff

I can help shed some light on this one. The utility (maintaindatastore) shipped with ArcGIS Data Store 11.4, but there was an issue with getting it properly documented. This will be fixed with the 11.5 release, but I can share some information in the meantime here.

The maintaindatastore utility can be used with the relational data store or the object store. When it is run, it has the potential to reclaim disk space.

For the relational data store, it frees up disk space by cleaning up any obsolete rows left behind during heavy edit operations against hosted feature layers.

For the object store, it deletes expired feature query caches on demand rather than waiting to delete them when scheduled by the administrator. Note: when the utility is used with the object store, it restarts the object store as this is necessary to reclaim the disk space.

Here is the syntax that can be used to run the utility at ArcGIS Enterprise 11.4 (run it on the primary data store machine if your system is highly available):

Syntax
maintaindatastore --store {relational | object} [--prompt {yes|no}]

I hope this information is useful, and I appreciate you asking the question!

RyanUthoff

Awesome, thank you! And I appreciate you taking the time to clarify that information for me. I've been looking forward to a tool like that for a long time. We collect a lot of photos in S123 but even after deleting them, the space isn't released back to the OS and it's not sustainable to keep on adding and adding HDD space.

We're able to connect to the data store PostgreSQL DB directly and do the vacuum in PGAdmin, but we'd prefer to do things in the more "Esri approved way" and it's good to know there is now an official tool that will do it for us.

Thank you!