| Author |
Message |
 Topic: bash script to monitor queue depth using qload |
dean
Replies: 4
Views: 20342
|
 Forum: IBM MQ Performance Monitoring Posted: Wed Oct 27, 2010 6:53 am Subject: bash script to monitor queue depth using qload |
Thanks for the idea. This seems to work.
$curdepth=(`echo 'DISPLAY QUEUE (queuename) CURDEPTH' | runmqsc DV01 | grep 'CURDEPTH(' | tr '(' ' ' | tr ')' ' '`)
$echo ${curdepth[1]}
3068 |
| Topic: bash script to monitor queue depth using qload |
dean
Replies: 4
Views: 20342
|
Forum: IBM MQ Performance Monitoring Posted: Wed Oct 27, 2010 6:04 am Subject: bash script to monitor queue depth using qload |
Is there a way using qload to monitor the queue depth? I haven't found a way to pipe the summary information from qload to a file. Is there another way from a bash script to monitor queue depth?
... |
| Topic: Intermittent errors updating SQL Servers |
dean
Replies: 2
Views: 4167
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 03, 2009 4:48 am Subject: Intermittent errors updating SQL Servers |
Are there WMB or ODBC settings that will compensate if it is a load issue?
Where can I find documentation on these type of errors?
Thanks for the response. |
| Topic: Intermittent errors updating SQL Servers |
dean
Replies: 2
Views: 4167
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 03, 2009 2:48 am Subject: Intermittent errors updating SQL Servers |
| I am seeing intermittent errors when executing stored procedures against SQL Servers from within ESQL. Below are two of the exception lists showing SQLSTATE 20122 and at different times "Timeout ... |
| Topic: mqtt parallel testing |
dean
Replies: 0
Views: 1850
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 20, 2009 6:12 am Subject: mqtt parallel testing |
Is there a way to subscribe to MQTT messages within a message flow from another broker? Or, is there a utility available that will subscribe to one broker and publish the data to another broker?
I ... |
| Topic: converting from a timestamp to epoch time |
dean
Replies: 7
Views: 12594
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 17, 2009 4:30 am Subject: solution |
this worked for me:
DECLARE HrTmStmpSec INTEGER CAST ((datestamp - TIMESTAMP '1970-01-01 00:00:00') SECOND as INTEGER);
thanks to all.
:clap: |
| Topic: converting from a timestamp to epoch time |
dean
Replies: 7
Views: 12594
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 13, 2009 4:48 am Subject: invalid characters error |
thanks for the reply. I'm getting the following error trying to use your suggestion. Any ideas?
DECLARE HrTmStmpSec INTEGER (TIMESTAMP '2009-06-16 14:18:23' - TIMESTAMP '1970-01-01 00:00:00') SEC ... |
| Topic: converting from a timestamp to epoch time |
dean
Replies: 7
Views: 12594
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Aug 12, 2009 10:39 am Subject: converting from a timestamp to epoch time |
This works going from epoch to a timestamp:
SET HrTmStmpSec = TIMESTAMP '1970-01-01 00:00:00' + CAST(InputRoot.MRM.cstdatestamp AS INTERVAL SECOND);
How would I do the reverse -- convert from a ti ... |
| Topic: performance report stats for databases updates |
dean
Replies: 3
Views: 3149
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 16, 2009 9:57 am Subject: performance report stats for databases updates |
I'm still comparing apples and oranges. The stored procedure referenenced doesn't do anything.
I'll just have to experiment...but I expect the stored procedure call to update a database will be fa ... |
| Topic: performance report stats for databases updates |
dean
Replies: 3
Views: 3149
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 16, 2009 8:29 am Subject: performance report stats for databases updates |
Yes, I didn't understand what was going on in the compute node. It would be nice to compare the 2000 stored procedure calls per message to 2000 database updates per message.
By looking at the mini ... |
| Topic: performance report stats for databases updates |
dean
Replies: 3
Views: 3149
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 15, 2009 12:40 pm Subject: performance report stats for databases updates |
| The Linux performance report for WMB indicates that 688 messages per second (in the test lab) can be processed using a Database Update (on page 32). But it says that using a stored procedure drops p ... |
| Topic: Suggestions for reprocessing MQTT messages |
dean
Replies: 3
Views: 3164
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 05, 2009 12:18 pm Subject: Suggestions for reprocessing MQTT messages |
I'm used to troubleshooting with log files. I could just as easily view the messages from a queue and then move them to another queue to be reprocessed.
Is there a way to archive queue data to a f ... |
| Topic: Suggestions for reprocessing MQTT messages |
dean
Replies: 3
Views: 3164
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 05, 2009 11:53 am Subject: Suggestions for reprocessing MQTT messages |
| I'm looking for suggestions on how to save ScadaInput (MQTT) messages to a text file and then have a way to run them through the workflow again later. One thought I had was to route the ScadaInput no ... |
| Topic: How to convert character to an ASCII code |
dean
Replies: 3
Views: 3506
|
Forum: General IBM MQ Support Posted: Fri May 29, 2009 6:53 am Subject: How to convert character to an ASCII code |
| Thank you. The SUBSTRING solution will work just fine. |
| Topic: How to convert character to an ASCII code |
dean
Replies: 3
Views: 3506
|
Forum: General IBM MQ Support Posted: Fri May 29, 2009 5:21 am Subject: How to convert character to an ASCII code |
Using ESQL, how can I convert the letters of the alphabet into their ASCII code values -- A = 65, B=66, ... Z=90.
Of course this could be done with a massive case statement...but what fun would tha ... |
