Spencer_Cockrell_39

Excluding Statistics during Database Maintenance

Discussion created by Spencer_Cockrell_39 on Apr 17, 2017
We've received a couple of questions lately regarding how to exclude statistics when performing a Database Unload via our Utilities, so I wanted to put together a post explaining how to accomplish this requirement. You can exclude these via the Archive/Reorg GUI (ucybdbarg and ucybdbreg, respectively) and selecting the Settings menu option. From here, you can select the Statistics sub-tab:

Archive Utility:

5ujjqzg52pp7.png

Reorg Utility:

lqn58g7bug53.png

If you are calling these Utilities from the command line, the following variables are going to become relevant:

UC_UTILITY_ARCHIVE:
https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE/11.2/All%20Guides/help.htm#ucachl.htm%3FTocPath%3DAdministration%2520Guide%7CConfiguration%7CSettings%2520in%2520Variables%7C_____28

UC_UTILITY_REORG:
https://docs.automic.com/documentation/webhelp/english/AWA/11.2/AE/11.2/All%20Guides/help.htm#ucachm.htm?

The Key you are specifically looking to reference will be "AH" within these variables (set to FALSE). 

Outcomes