Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2013-10-16T04:56:39Z by mattiasgreen
AnupKum5
AnupKum5
2 Posts
ACCEPTED ANSWER

Pinned topic Process Engine Event Log Purging

‏2013-10-12T09:52:36Z |

I looking for possible solutions for purging event logs from FileNet Process Engine. We have Process Engine 4.5.1 installed on Win 2008 with Db2 9.5 as database.

VWDB Database size :  252 GB
Single table F_SW.VWLOG1_164 (Event Log table) size in this database is  251 GB

Please let me know best way to purge the event log data.

  • mattiasgreen
    mattiasgreen
    2 Posts
    ACCEPTED ANSWER

    Re: Process Engine Event Log Purging

    ‏2013-10-16T04:52:48Z  in response to AnupKum5

    The best way to purge the log data in your particular case is hard to tell, just by looking at the information you've provided. Have you taken a look at the documentation?

    Note! You should be very careful before running this tool. You probably want to make sure that you are not removing log data for running work objects, depending on your needs, of course.

    "Use the vwlog utility to move log records and purge log data from the Process Engine database for a single virtual server Process Engine system.

    The vwlog utility runs on any Process Engine virtual server. The machine where you installed the Process Engine can host multiple virtual servers. Thus, when you are on a particular machine and you want to run vwlog in a particular virtual server, you must supply a virtual server name. If you want to work on the default one, you can skip this parameter."

    http://pic.dhe.ibm.com/infocenter/p8docs/v5r1m0/topic/com.ibm.p8.pe.vw.doc/bpfvw006.htm

    Updated on 2013-10-16T04:57:05Z at 2013-10-16T04:57:05Z by mattiasgreen