Can a batch job be established that will trigger automatic deletion of data in the Database Analyzer for Db2 statistics tables

Products

• Database Analyzer for DB2 for z/OS

Issue/Introduction

Can a batch job be established that will trigger automatic deletion of data in the Database Analyzer for Db2 for z/OS (PDA) statistics tables.

Resolution

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.

Example:
//STEP1 EXEC PGM=PTLDRIVM,PARM='EP=RALMCTL/MAINT=Y'