Asset Suite / PassPortGeek

Are you having trouble with online access to the IB Monitor error messages? Try the following SQL's:

select err.*, sub.ibpubtransactid
 from sysadm.psiberr err
        ,sysadm.PSAPMSGSUBCON sub
        --Archived
        --,sysadm.PSAPMSGARCHSC sub
 where sub.queuename = 'Queue Name'
    and sub.queueseqid = Queue Sequence ID
    and sub.ibtransactionid = err.ibtransactionid
;
select err.*, sub.ibpubtransactid
  from sysadm.psiberrp err
         ,sysadm.PSAPMSGSUBCON sub
 where sub.queuename = 'Queue Name'
    and sub.queueseqid = Queue Sequence ID
    and sub.ibtransactionid = err.ibtransactionid
    order by queueseqid desc, seqno
;

select err.*, msg.ibpubtransactid
  from sysadm.psiberrp err
-- ,sysadm.PSAPMSGSUBCON msg
-- ,sysadm.psapmsgarchsc msg
,sysadm.psapmsgpubcon msg
-- ,sysadm.psapmsgarchpc msg
-- where msg.queuename = 'BPFI_PROJ_ACT_CHNL'
-- where msg.queuename = 'BPFI_PU_INSERV_CHNL'
-- and msg.ibpubtransactid = 'f9d8efd7-3d06-11df-99ee-90ec519de57b'
-- and msg.ibpubtransactid = '34a98ad0-5140-11df-856f-ac8a820812ce'
-- and msg.ibpubtransactid = '44a10af0-4ef8-11df-af22-eef2bde9316e'
-- and msg.IBPUBTRANSACTID = '0fb88c44-523d-11df-856f-ac8a820812ce'
where msg.IBPUBTRANSACTID = '7e864bac-5857-11df-9635-9a0bddc172a5'
-- and msg.subqueue like 'TRANS00251568%'
-- and msg.SUBQUEUE like 'TRANS00258520%'
-- and msg.SUBQUEUE like 'TRANS00197159'
-- and msg.subqueue like 'TRANS00240270%'
-- and msg.queueseqid = Queue Sequence ID
-- and msg.ibpubtransactid = '38151a5f-2180-11df-b6d8-b9758dd8a605'
and msg.ibtransactionid = err.ibtransactionid
order by queueseqid desc, seqno
;