IMPACT OF DELETING PSM STATS.

book

Article ID: 49513

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Analyzer for DB2 for z/OS CA Fast Unload for DB2 for z/OS CA Fast Check for DB2 for z/OS CA Fast Index for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Rapid Reorg for DB2 for z/OS

Issue/Introduction

Question: 

1-Are there any impact on DB2 work areas for deleting stats in PSM? 

2-What is the best way to clean PPA stats?

Answer: 

1-When you delete in stats manager for a strategy version you're cleaning up the internal stats manager tables which reside in database PTDB.
PSM specifically does deletes against these tables:PTPS_SYSSTATS_0702, PTPS_STRAT_0702 , PTPS_OBJECTS_0702 and PTPS_MASKS_0702.

When deleting stats no other action is done against DB2 or any other object besides the ones mentioned above.

2-The recommended way to delete a statistics strategy or a strategy version is to use the D line command next to the name of the statistics strategy or strategy version to delete from the 'Statistics Manager Strategy Services panel'

Environment

Release:
Component: PPADB2