MQSeries.net :: View topic - Another database problem, "the WMB is slow"

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 » WebSphere Message Broker (ACE) Support » Another database problem, "the WMB is slow"

Goto page Previous 1, 2

Another database problem, "the WMB is slow"

« View previous topic :: View next topic »

Author

Message

kimbert

Posted: Wed Mar 12, 2014 8:04 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

I got sufficiently interested to ask one of the IIB developers about this. Here's their answer:

Quote:

The better IIB answer here is the ODBC activity log that was added in V9.

An SQLExecute is now surrounded by a BIP12074 and BIP12075 (successful) or BIP12077 (unsuccessful).
Therefore it should be possible to view the two timestamps and see exactly how long the DB statement took to execute.

We also do the same for SQLPrepare using the BIP12080 and BIP12081 (successful) or BIP12082 (unsuccessful)

Activity logging is always on and can be logged to a file if needed.

Definitely available in IIB v9. I believe it's also available in any version after WMB v8.0.0.2.
_________________
Before you criticize someone, walk a mile in their shoes. That way you're a mile away, and you have their shoes too.

mqceries

Posted: Tue Mar 18, 2014 7:47 am Post subject:

Acolyte

Joined: 02 Dec 2011
Posts: 70

Very Nice RFE.. just given my vote. lets see how it goes.

Display posts from previous:

Goto page Previous 1, 2

Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Another database problem, "the WMB is slow"

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