Topic
  • 2 replies
  • Latest Post - ‏2013-10-16T04:56:39Z by mattiasgreen
AnupKum5
AnupKum5
2 Posts

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

    Re: Process Engine Event Log Purging

    ‏2013-10-16T04:52:48Z  

    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
  • mattiasgreen
    mattiasgreen
    2 Posts

    Re: Process Engine Event Log Purging

    ‏2013-10-16T04:56:39Z  

    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

    You may also need to tweak the settings, since your database already is quite big. You may run into transaction roll-backs due vwlog operations taking too long time to complete with the default settings. See the following IBM tech note.

    http://www-01.ibm.com/support/docview.wss?uid=swg21384885