search cancel

How Do I clean up Statistics Manager(PSM) versions?

book

Article ID: 21391

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction

Question: 

It was noticed that every time the copy or migrate job is run a new row is added to the Statistics Manager Strategy Services screen within Statistics Manager. Where is this data stored and how does one automate the cleanup/deletion of that data?

Answer: 

The tables PTI.PTPS_SYSTATS_# and PTI.PTPS_DBASTATS_# store the statistics collected for the PSM strategy versions (import, export, rollback, load, unload).

Statistics Manager (PSM) does not currently have the ability to limit the strategy versions like PPA.

MAX_#_VERS is a PPA parmlib option and PSM does not read any of the PPA parmlib options.

The only way to delete these PSM strategy versions is by entering statistics manager and deleting each unwanted PSM strategy version.

 

The PSM tables are described in Appendix C in PPADB2 Reference Guide.

 

Environment

Release:
Component: PPADB2