ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexGeneral IBM MQ SupportV9.x Performance Events

Post new topicReply to topic
V9.x Performance Events View previous topic :: View next topic
Author Message
bobbee
PostPosted: Wed Mar 11, 2020 7:20 am Post subject: V9.x Performance Events Reply with quote

Chevalier

Joined: 20 Sep 2001
Posts: 434
Location: Tampa

Can MQ Performance event be configured to publish when Long Running tasks are encountered? Would suspect the time would be specified.
Back to top
View user's profile Send private message Send e-mail AIM Address
hughson
PostPosted: Wed Mar 11, 2020 1:33 pm Post subject: Re: V9.x Performance Events Reply with quote

Grand Master

Joined: 09 May 2013
Posts: 1378
Location: Bay of Plenty, New Zealand

bobbee wrote:
Can MQ Performance event be configured to publish when Long Running tasks are encountered? Would suspect the time would be specified.


I can't think of an event that the queue manager emits as a result of a long running task. However, you could monitor for this using Accounting records. If you get an Accounting record that indicates the connection duration has been longer than your required time, it could alert in whatever way your monitoring tools allows.

Please feel free to contact me offline for how our tools can do this, but any monitoring tool that processes Accounting records ought to be able to do it.

Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software
Back to top
View user's profile Send private message Visit poster's website
gbaddeley
PostPosted: Wed Mar 11, 2020 3:53 pm Post subject: Reply with quote

Jedi

Joined: 25 Mar 2003
Posts: 2097
Location: Melbourne, Australia

Do you mean Long Running tasks (where app processes are connected for a long time, or have queues open for a long time), or do you mean Long Running Units Of Work (where app processes are holding uncommitted messages in an active syncpoint for a long time) ?
_________________
Glenn
Back to top
View user's profile Send private message
bobbee
PostPosted: Thu Mar 12, 2020 5:50 am Post subject: Reply with quote

Chevalier

Joined: 20 Sep 2001
Posts: 434
Location: Tampa

This would be Long LUW from the looks of the log messages. They look to have 4-9 MQGETS out under sync-point for anywhere from 2600 to 9870 seconds. This is coming from an API exit. I do not have access to the code and wanted to write a script of commands or get published system stats to validate and allow the support team to see for themselves. The support team is very proactive and I would like to empower them a little more.
Back to top
View user's profile Send private message Send e-mail AIM Address
hughson
PostPosted: Thu Mar 12, 2020 9:53 pm Post subject: Reply with quote

Grand Master

Joined: 09 May 2013
Posts: 1378
Location: Bay of Plenty, New Zealand

2600 - 9870 seconds is 43 - 164 minutes! That is long.

This doesn't seem to be something that Accounting and Statistics can help you with, nor events.

However, you can see long-running UoWs by using DISPLAY CONN (it was designed for this exact purpose - "Who's got my long running UoW" was it's working title!).

However, you need to bear this quirk in mind.

Use a command like the following:-

Code:
DISPLAY CONN(*) ALL WHERE(UOWLOGTI NE ' ')


to show all connections that have an uncommitted UoW that has actually involved the log.

If you want to look for the long UoWs, then you need to compare the two fields UOWLOGDA and UOWLOGTI with the current time to see how long they are.

<vendor_plug>
Using MQSCX you can do this as follows:-
Code:
********************************************************
* Script to detect long-running UoWs
* Check for those older than 2 minutes (120 seconds)
********************************************************
@ageboundary = 120
@countUoW    = 0

foreach(DISPLAY CONN(*) ALL WHERE(UOWLOGTI NE ' '))
  @uowage = _time - mqtime(UOWLOGDA,UOWLOGTI)
  if (@uowage > @ageboundary)
    @countUoW = @countUoW + 1
    print "Long-running UoW (",:n:@uowage,"seconds) for application", :s:APPLTAG
    if (CHANNEL)
      print "over channel", CHANNEL, "from IP address", :s:CONNAME
    endif
    print "from user", USERID
  endif
endfor
if (@countUoW = 0)
  print "No long-running UoW older than", @ageboundary, "seconds"
endif


which would give the following output if it found one, although of course you can print out anything you like.

Code:
Long-running UoW (147 seconds) for application d:\nttools\q.exe over channel MQGEM.SVRCONN from IP address 127.0.0.1 from user mqgemusr

</vendor_plug>

Cheers,
Morag
_________________
Morag Hughson @MoragHughson
IBM MQ Technical Education Specialist
Get your IBM MQ training here!
MQGem Software


Last edited by hughson on Fri Mar 13, 2020 3:04 pm; edited 1 time in total
Back to top
View user's profile Send private message Visit poster's website
bobbee
PostPosted: Fri Mar 13, 2020 4:49 am Post subject: Reply with quote

Chevalier

Joined: 20 Sep 2001
Posts: 434
Location: Tampa

Thanks Morag, Perfect. I like the Vendor XML tag
Back to top
View user's profile Send private message Send e-mail AIM Address
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexGeneral IBM MQ SupportV9.x Performance Events
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


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.