| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| [Solved] Deleting records from audit trail for finished proc |
« View previous topic :: View next topic » |
| Author |
Message
|
| Milesi |
 Posted: Tue Mar 09, 2004 1:14 am Post subject: [Solved] Deleting records from audit trail for finished proc |
 |
|
Apprentice
Joined: 15 Apr 2002
Posts: 37
|
Hello,
It is mentioned in the WF administrator guide that:
If you want to delete all records from the audit trail table that belong to processes that have been finished prior to the specified time stamp. If you use the finished option, it is recommended that you create an index on the audit trail table as follows:
For DB2:
Create an index on the audit trail table fmc.audit_trail with the column TOP_LVL_PROC_ID as index key. To enable the index, you must run the DB2 runstats command on the table fmc.audit_trail and rebind the package fmc.fmcdbad2.pkg. For details about how to create an index, refer to the DB2 documentation.
We did check the documentation and found that the following command must be ran:
create index fmc_Audit_trail_PROC_ID on fmc.audit_trail(TOP_LVL_PROC_ID)
db2 runstats on table fmc.audit_trail
db2 bind PATH\fmcdbad2.bnd
Unfortunatly we didn't find anything specifying if the index needs be unique and if it should be ascending or descending.
Thank you for your help.
Regards
Last edited by Milesi on Mon Mar 15, 2004 4:36 am; edited 1 time in total |
|
| Back to top |
|
 |
| mzg |
| Posted: Tue Mar 09, 2004 3:40 am Post subject: |
|
|
Newbie
Joined: 01 Oct 2003
Posts: 8
|
There are usually multiple entries with the same top level process id (e.g. for each activity in the process), so the index cannot be unique.
Ascending or Descending might not make a lot of sense either, since the ID generator is supposed to more or less randomly spread the IDs across the relevant namespace.
Maybe there is a small preference of ascending over descending (afair).
Creating and using the index at all is what should provide a major improvement.
_________________
Cheers,
Richard.
-----------------------
IBM Websphere MQ Workflow & Process Choreographer Performance Focal Point |
|
| 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
|
|
|
|
