| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ Long Running Task Scripts |
« View previous topic :: View next topic » |
| Author |
Message
|
| bobbee |
 Posted: Mon Apr 03, 2023 11:08 am Post subject: MQ Long Running Task Scripts |
 |
|
Knight
Joined: 20 Sep 2001
Posts: 545
Location: Tampa
|
I wrote a shell and Python script to search and display Long Running Tasks with an outstanding LUW. The are available to anyone that wants to use them. Good for when you get that 'Out of Log Space' Message.
https://github.com/rkbroder/MQ-Logic-Unit-of-Work |
|
| Back to top |
|
 |
| gbaddeley |
| Posted: Mon Apr 03, 2023 3:46 pm Post subject: |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
Hi Bobbee,
Good work. The 100 lines of bash script code to parse the MQSC output can be done in about 10 lines of awk, but your code is very clear and has comments.
I have a korn shell script (for AIX & Linux) that takes a different approach. It accepts a queue name and type pattern, and gets connection info using "display conn(*) where(objname eq \" qname "\) all"
It then reports on queues, showing all the UOW related attributes, and info on the qmurid, appltag, channel, ip address, userid of who has the queue open, and qstatus info related to uncommitted messages.
It can also produce an "aged log writes" report that sends an email if any UOWs are over a specified age, eg. 10 minutes. This allows action to be taken before there is any impact to the logs.
Long running UOWs were an issue for us about 10 years ago, but in recent times we haven't had any trouble.
_________________
Glenn |
|
| Back to top |
|
|
| hughson |
| Posted: Mon Apr 03, 2023 3:54 pm Post subject: |
|
|
Padawan
Joined: 09 May 2013
Posts: 1959
Location: Bay of Plenty, New Zealand
|
|
| 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
|
|
|
|
