| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Effective way to clear failed flows on ICS |
« View previous topic :: View next topic » |
| Author |
Message
|
| harish_td |
 Posted: Wed Jun 14, 2006 7:24 pm Post subject: Effective way to clear failed flows on ICS |
 |
|
Master
Joined: 13 Feb 2006
Posts: 236
|
Hi All,
We have more than 13000 failed flows on ICS.
Deleteing each failed flows takes up more than a couple of minutes.
Could anyone suggest a method to clear all these flows such that the CPU utilization does not go up.
Thanks in Advance,
Harish |
|
| Back to top |
|
 |
| Sriver |
| Posted: Thu Jun 15, 2006 12:13 am Post subject: |
|
|
Newbie
Joined: 08 Jun 2006
Posts: 6
|
Hi,
as last change u could clean up the corresponding tables which contains the data flows, and the AP queue where the message are stuck as well.
Then restart the server.
U can use this script for an Oracle DB:
DELETE FROM CXFAILEDEVENTKEYS;
DELETE FROM CXPBUSOBJMESSAGE;
DELETE FROM CXPBUSOBJSTATE;
DELETE FROM CXWIPBLOBS;
DELETE FROM CXWIPOBJECTS;
COMMIT;
Anyway, this is highly not recomendated to manipulate the DB manually, so is up to u.......
Regards |
|
| Back to top |
|
|
| Kram |
| Posted: Thu Jun 15, 2006 6:22 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006
Posts: 87
|
Make sure you do this after bringing the environment down....
_________________
Regards,
Ram |
|
| 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
|
|
|
|
