| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Multiple database calls in compute node..able to get timing? |
« View previous topic :: View next topic » |
| Author |
Message
|
| moogoo |
 Posted: Tue Mar 07, 2006 12:15 pm Post subject: Multiple database calls in compute node..able to get timing? |
 |
|
Acolyte
Joined: 20 Sep 2002
Posts: 54
Location: US
|
Hi,
We have a compute node that makes numerous function calls to a database to retrieve information that will be used to enrich the incoming data. I'd be interested to know whether it would be possible to be able to retrieve a time when the database call is invoked and then retrieve a separate time after the call. Unfortunately, the builtin CURRENT_TIMESTAMP ESQL function always returns the same timestamp for the compute node regardless of where the actual code resides within it and for the life of me, haven't been able to figure out a way around this.
Does anybody have any suggestions on this? Separating out the function calls into different nodes is not an option at this point since the system is very mature and somewhat complex. As an FYI, we are currently running V2.1, but am looking to migrate to V6.0 by mid year.
Thanks for your time!
MG |
|
| Back to top |
|
 |
| mgk |
| Posted: Tue Mar 07, 2006 12:42 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
The behaviour of CURRENT_TIMESTAMP is by design. To get the behaviour you want you could::
In V-2.1, you could make another call to your DB to return a timestamp before and after each actual DB call.
In V-6 You could call from ESQL into Java to return you a timestamp before and after each DB call.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| moogoo |
| Posted: Fri Mar 10, 2006 12:30 pm Post subject: |
|
|
Acolyte
Joined: 20 Sep 2002
Posts: 54
Location: US
|
Thanks, MGK. I thought I'd be able to get around that with V6.0 by placing the actual function definition in a separate ESQL file than the compute node that would actually call it. But from my testing, this also appears to give the same system time.
MG |
|
| Back to top |
|
|
| JT |
| Posted: Fri Mar 10, 2006 3:35 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Quote: |
| I'd be interested to know whether it would be possible to be able to retrieve a time when the database call is invoked and then retrieve a separate time after the call. |
Will you being doing something programatically with this value or is it that you just want to know how much time is being spent on the database calls?
If it's the latter, a trace (odbc or user) will provide these numbers for you. |
|
| 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
|
|
|
|
