Need Purge of Data when database removed from DB2Collect


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


RodHansen wrote Feb 9 at 1:58 PM

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

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