| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| large audit DB Size with full audit |
« View previous topic :: View next topic » |
| Author |
Message
|
| tsrisudh |
 Posted: Wed Aug 02, 2006 6:36 am Post subject: large audit DB Size with full audit |
 |
|
Centurion
Joined: 11 Aug 2005
Posts: 113
|
We have a workfloe system with full audit tured on for WBI monitor purpose. Now we envisage that in 3 months time we will have around 500k to 600k workflow instances, which means with the activity we will have the size of the audit DB will be anywhere between 50 - 60 GB.
Now in real time environments how do we manage such large database and as time goes on this size keeps growing, so what is the best way to manage thie audit DB in long term perspective, even if the normal workflow instances finish their data will be present in the audit DB and potentially leat to huge size of the DB which makes it un manageable.
So please suggest as to what is usually done in this kind of scenarios.
_________________
Srisudhir Tadepalli |
|
| Back to top |
|
 |
| JKehoe |
| Posted: Thu Aug 03, 2006 10:14 am Post subject: |
|
|
Novice
Joined: 10 Aug 2005
Posts: 20
|
A couple of suggestions:
1) Considering changing from full audit to condensed or to filter and just capture the events that you are interested in.
2) Routinely run the Audit table cleanup utility (fmcsclad). This utility takes a parameter where by you can specify if you want to delete everything associated with a PI that is finished, or, delete all events created before a certain date.
3) I'm not sure what your configuration is, but if you're using the Web Client with the default out-of-the-box settings, you may want to rewrite using a Virtual User strategy. This way, only one workitem gets created per process instance instead of one workitem per user per process instance. This will drastically cut down on the number of workitems and the amount of events in the audit trail table.
good luck,
josh |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
