Can a batch job be established that will trigger automatic deletion of data in the statistics tables?

Document ID : KB000055874
Last Modified Date : 14/02/2018
Show Technical Document Details

Yes, this is possible.
The delete process must first be activated by setting Auto-Statistics Activation to 'Y' and defining options on the Automatic Statistics Deletion panel found via option 3.1 on the PDA main menu. Subsequent batch extract executions will check the established delete options to determine if deletion of all or some statistics should occur. Keep in mind that stats deletion could add time and overhead to the extract job. Its possible to override the process by adding "/MAINT=Y' or "/MAINT=N' to the exec statement, where 'Y' indicates to run the deletes and N means to disallow them.