what is count refers in jbm_postoffice table by JBoss messaging

[nagarjuna.a]

Hi ,

we are using JBoss SOA 3.1 cluster nodes and using oracle database for ESB message persistence. when we query as below,

"SELECT r.channel_id, po.queue_name,po.node_id, po.cond, COUNT(*) COUNT

FROM jbm_msg_ref r, jbm_postoffice po

WHERE r.channel_id = po.channel_id

GROUP BY r.channel_id ,po.queue_name, po.cond,po.node_id

ORDER BY COUNT DESC"

we are getting result as

CHANNEL_ID     QUEUE_NAME                                  NODE_ID             COND                                                    COUNT

481                         001.ESB.Test.In                          53                           queue.001.ESB.Test.In                          133239

----------------------------------------------------------------------------------------------

Is the above query result saying

whether the COUNT=133239 specifies, messages persisted by PersistenceManager for 001.ESB.Test.In are delivered by PostOffice to  final  destination ‘queue.001.ESB.Test.In’

or

Count of messages yet to be delivered by PostOffice since we are querying based on corresponding CHANNEL_ID in both tables jbm_msg_ref & jbm_postoffice.

I don't have any idea about internals of postoffice and serverPeer.

please help in understanding this.

Thanks & Regards,

Nagarjuna

[tcunning]

Nagarjuna,

What information are you looking for exactly?    If you are looking for ESB metrics, there are a number provided for you in the admin console :

http://localhost:8080/admin-console

You can browse down under "JBoss ESB" and get information on deployments on a service and action basis.

[nagarjuna.a]

Thanks Tom for reply.

Actually i would like to know,

how jms serverpeer and post office deliver messages to JMS queues.?

what are the descriptions for columns in 'jbm_msg_ref' and 'jbm_postoffice' jboss messaging tables ? (if any kind of documentation present)