SQL to help find why messages are status NEW in the Integration Broker Monitor.
select * from sysadm.psapmsgsubcon
where queuename = 'Queue Name'
and statusstring not in ('DONE','CNCLD')
-- where subqueue like 'TRANS00025336%'
order by lastupddttm desc
What's currently going on in the Integration Broker Queue?
SQL to help find why messages are status NEW in the Integration Broker Monitor.
select * from sysadm.psapmsgsubcon
where queuename = 'Queue Name'
and statusstring not in ('DONE','CNCLD')
-- where subqueue like 'TRANS00025336%'
order by lastupddttm desc