Lotus Nut

With Lotus Connections 2.5, the PEOPLEDB database has an EVENTLOG table that keeps track of each status update, photo update, colleague addition, tagging, wallpost creation, etc... The problem is that none of this is cleaned up over time. And I am unable to find this documented anwhere. The closest I can find is a post aboutsetting up a CRON job for cleaning up Communities.  Here at BleedYellow, the PEOPLEDB was slowly growing - up to over 23GB! The EVENTLOG table had over 14 million records!!

 

So, here are the commands that you can run (or schedule) from wsadmin (profilesAdmin.py, of course) to clean up this table:

 

ProfilesService.purgeEventLogs()  - purge all of the logs in EVENTLOG table.

ProfilesService.purgeEventLogsByDates("09/24/2009", "10/01/2009") - just put in the start and end date for the cleanup. Depending on the number of records, you may be able to only cleanup a few months at a time.
ProfilesService.purgeEventLogsByEventNameAndDates("profiles.person.selftagged", "11/01/2009", "11/30/2009") - this keys off of the EVENT_NAME column. Possible values include, but are not limited to, profiles.person.selftagged, profiles.updated, profiles.status.updated, profiles.person.photo.updated. While you're looking at this with your PEOPLEDB, check out the other values in that column.

 

Also, you may receive a "SocketTimeoutException: Read timed out" error. If so, you'll need to "increase the timeout value specified by the com.ibm.SOAP.requestTimeout property in the soap.client.props file".