[Translated from mos] controlling the Repository Table retained for several days in OGG ctor, mosrepository
Controls the Repository Table retained for several days in OGG Director
Translated from mos:
Can I Purge The Director "STATSENTRYB" Repository Table? (Docid 971709.1)
QUESTIONMy Director Repository Table "STATSENTRYB" has grown to more than 100,000 rows. Is there a way to purge that table? SOLUTIONThere is a parameter to control how long records are retained in this table. using the Director Admin Tool, click on the Monitor Agent Tab. the Log Purge Hours controls the number of hours records are retained in both the "STATSENTRYB" and the "LOGENTRYB" tables. the default is 72 hours. once you make a change to that parameter, hit the Save and Restart Button. this will update the Database Repository but you will have to also reboot the Director Server for it to pickup and apply this change.