Deleting rows from PSM (Statistical Manager) tables
search cancel

Deleting rows from PSM (Statistical Manager) tables

book

Article ID: 49729

calendar_today

Updated On:

Products

Plan Analyzer for DB2 for z/OS

Issue/Introduction

There are unneeded versions of strategies that need to be cleaned up from the PSM (Statistical Manager) tables.

  1. Can a query be written to clean up those rows?
  2. What are the tables involved in storing strategies versions data?
  3. Is there any RI built in to these tables.

Resolution

  1. Yes a simple query can be written to delete rows from the PSM tables.

  2. There are five PSM tables involved :
    PTPS_DBASTATS_1200
    PTPS_SYSSTATS_0702
    PTPS_STRAT_0702
    PTPS_OBJECTS_0702
    PTPS_MASKS_0702

    # is the suffix indicating the release e.g.1200, 0702

  3. No RI exists between these tables, but the same key NAME, CREATOR, PRODUCT and VERSION are used across all 5 tables.
    Potentially, you would want to delete the version from all 5 tables. VERSION = 0 is always the strategy and 1-n are the possible strategy versions.
Powered by Wolken Software