Monitoring Integration Broker Messages

To monitor these PUB messages, we can have a look in the tables below:

• PSAPMSGPUBCON
• PSAPMSGSUBCON
• PSIBLOGHDR
• PSAPMSGPUBHDR

The SQLs I am using to detect failed messages are:

select * from PSAPMSGPUBCON where STATUSSTRING='ERROR'

or, if want to see more:

select * from PSAPMSGPUBHDR HDR, PSAPMSGPUBCON CON where HDR.IBTRANSACTIONID=CON.IBPUBTRANSACTID and CON.STATUSSTRING not in ('DONE', 'CNCLD')

The STATUSSTRING can be replaced by PUBSTATUS, with its Status Codes:
0 - Error, 1 - New , 2 - Started, 3 - Working,
4 - Done, 5 - Retry, 6 - Timeout, 7 - Edited, 8 - Canceled


I believe it is not hard at all to jump from PUB messages to SUB messages. :)