MQSeries.net :: View topic - Audit Trail table

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Audit Trail table

Audit Trail table

« View previous topic :: View next topic »

Author

Message

mqworkflow

Posted: Fri Jun 03, 2005 4:28 am Post subject: Audit Trail table

Apprentice

Joined: 23 Feb 2004
Posts: 32

Can we drop the audit trail table and recreate it. We are having a tough time in deleting the records in it from fmcsclad.

Thanks

jmac

Posted: Fri Jun 03, 2005 5:21 am Post subject:

Jedi Knight

Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC

I have never dropped just the Audit table, like you suggest, so I do not know if it will work. However, if you do try this and it works pleas let us know.

There is a parameter that you can use in V3.4 and up that will speed things up a bit.

You can try FMC_NO_WORKITEM_CLEANUP=YES, simply set in your environment variables before you start MQWF.

Now, If you have never cleaned up your audit table and it has a very large number of records in it, this may not help much.
_________________
John McDonald
RETIRED

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Audit Trail table

Jump to:

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

Protected by Anti-Spam ACP