(DI-1902) Cleanup Extended Query Statistics
You can use report /DVD/QS_DELETE or transaction /DVD/QS_DEL for cleanup of extended query statistics that are collected in tables /DVD/QS_INFO and /DVD/QS_QVAR.
Scheduling cleanup
If you want to cleanup statistics regularly you need to create dynamic variant for report /DVD/QS_DELETE as follows.
- Open transaction SE38 and type report name
- Click on button
- Chose new variant name and click on button
- Click on button
- Create variable for field Date
- Press F4 on Selection variable column for Date filed and chose witch date (System Date or Local Date) should be used for dynamic calculation and confirm
- Press F4 on Name of Variable column for Date filed and chose select option that should be used for execution. In our case we chose everything less or equal than current day minus ??? days and confirm
- Now chose how many days should subtracted from current day and confirm
- Save variant
- Use created variant and schedule job that will be running on regular basis
- Press F4 on Selection variable column for Date filed and chose witch date (System Date or Local Date) should be used for dynamic calculation and confirm