Deleting rows from PSM (Statistical Manager) tables

Document ID : KB000049729
Last Modified Date : 14/02/2018
Show Technical Document Details



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.


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

  2. There are five PSM tables involved :

    # 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.