| Author |
Message
|
| hhenot |
 Posted: Mon May 22, 2006 1:06 am Post subject: length of messages |
 |
|
Newbie
Joined: 22 May 2006
Posts: 3
|
Hello,
I'm work with WBi and Websphere MQ.
For an IBM's audit, I must to have the length of differents messages in my system.
I'm searching and I found this information in MQJExplorer
But, It is not very pratical.
Do I find this information otherwise ?
Or, can I find this information in my database (ORACLE) ? if yes, what te name of the table ?
Thanks,
Hélène |
|
| Back to top |
|
 |
| Mr Butcher |
| Posted: Mon May 22, 2006 1:40 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
sorry, i do not understand. could you please make more clear what you are looking for?
_________________
Regards, Butcher |
|
| Back to top |
|
|
| hhenot |
| Posted: Mon May 22, 2006 2:00 am Post subject: |
|
|
Newbie
Joined: 22 May 2006
Posts: 3
|
I'm looking for the size of messages.
Where can I find this information ? |
|
| Back to top |
|
|
| Mr Butcher |
| Posted: Mon May 22, 2006 2:50 am Post subject: |
|
|
Padawan
Joined: 23 May 2005
Posts: 1716
|
only the application knows about the size of the messages. in mq you define maxmsglength, which ist just an upper limit, in queues, channels and qmgr, but it does not tell you what you really get.
go ask the application.
_________________
Regards, Butcher |
|
| Back to top |
|
|
| hhenot |
| Posted: Mon May 22, 2006 3:49 am Post subject: |
|
|
Newbie
Joined: 22 May 2006
Posts: 3
|
I found this information with the application "MQJExplorer", in the parameter "Message Data Length".
But, It's difficult to access at this information wih MQJExplorer...
I think this parameter is in Oracle Database.
But I don't know where... |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon May 22, 2006 5:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Find out the applications that are PUTTING the messages.
Ask the people who wrote those applications what the size of the messages they are putting is.
If Oracle DB is invovled at all, it is because some application is using it. NOT MQ, some other application.
Ask the people who wrote that application.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| jhalstead |
| Posted: Tue May 23, 2006 12:02 am Post subject: |
|
|
Master
Joined: 16 Aug 2001
Posts: 258
Location: London
|
Depending on your WMQ topology the messages emitted from this application might pass across dedicated channels. In which case you could view the channels status and see how many messages & bytes have been transmitted over a period of time. This will enable you to calculate an approximate average message size.
Bear in mind that whilst thereis a chance that your source application sends fixed length messages - on many occassions the amount of data in a message changes from message to message - e.g. An order could have many line items...
As already mentioned best place to start is with that application ssupport team, surely they have documentation for their developments?! 
Good Luck
Jamie |
|
| Back to top |
|
|
|
|
