1

Closed

Need Purge of Data when database removed from DB2Collect

description

When removing a database from Databases2Collect (either it has been dropped or you don't want to track it anymore), it doesn't remove the associated data. When Views like INDEX_STATS_CURR_VW run, it tries to join on a record that doesn't exist, therefore returning no data.
Closed Mar 15 at 9:30 PM by RodHansen
Already exists

comments

RodHansen wrote Feb 9 at 1:58 PM

Run the following command to purge data out you no longer need.
EXEC SP_PURGESTATS
      @PURGE_DAYS = -1,
      @DATABASE_NAME = '_database_name' --Use this option to delete all data for 1 database
      ,@SERVER_NAME = 'XXXXXXXXXXXXXX'

frugecn wrote Feb 9 at 7:49 PM

Thanks. It would just be nice to have if you are removing 20 DBs out of the list. Found the jobs weren't completing with 70+ Databases. (I haven't had a chance to look at why, though.)

wrote Mar 15 at 9:30 PM