| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Possible to get different time using CURRENT_TIME in 1 node? |
« View previous topic :: View next topic » |
| Author |
Message
|
| moogoo |
 Posted: Thu Dec 05, 2002 2:04 pm Post subject: Possible to get different time using CURRENT_TIME in 1 node? |
 |
|
Acolyte
Joined: 20 Sep 2002
Posts: 54
Location: US
|
Hi all,
According to the ESQL Reference, using the CURRENT_TIME function w/i the same node will return the same value. However, I would like to be able to get different times in different parts w/i the same compute node to see how long certain parts of code take to execute. This would be extremely helpful to see how long a database call would take and if it is a performance laggard and needs to be improved upon.
Does anybody have any suggestions on how to do this?
Thanks,
MG |
|
| Back to top |
|
 |
| Ian |
| Posted: Fri Dec 06, 2002 2:38 am Post subject: |
|
|
Disciple
Joined: 22 Nov 2002
Posts: 152
Location: London, UK
|
Hi MG,
Within nodes the CURRENT_TIME and CURRENT_TIMESTAMP type functions resolve to a constant which is set at the start of the processing within a node. Hence, the statement "all calls to CURRENT_ within the processing of a one node are guaranteed to return the same value".
The way to analyse the ESQL processing (processing path, performance or bottlenecks etc) is to take a WMQI User level trace as this logs a timestamp for each ESQL statement.
_________________
Regards, Ian |
|
| Back to top |
|
|
| moogoo |
| Posted: Mon Dec 09, 2002 5:00 am Post subject: |
|
|
Acolyte
Joined: 20 Sep 2002
Posts: 54
Location: US
|
Ian,
Thanks. You turn on user level trace by simply right clicking on the msg flow in operations and choosing "debug" correct? Then format the logs using the command line executables (in NT/2000)?
Jim |
|
| 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
|
|
|
|
