Looping messages can be stopped by pausing the channel in Application Designer. The following SQLs will cancel messages in statuses that block the channel. Data Mover script appmsgpurgeall.dms can also be used.
delete from sysadm.psapsmsgpubcerrp
where chnlname = 'channel name'
;
delete from sysadm.psapmsgpubcerr
where chnlname = 'channel name'
;
delete from sysadm.psapmsgpcondata
where chnlname = 'channel name'
;
update sysadm.psapmsgpubcon
set statusstring = 'CNCLD'
,lastupddttm = to_date(2006010101', 'yyyymmddHH24')
,pubconstatus = 8
where chnlname = 'channel name'
and not statusstring in ('DONE','CNCLD')
;
update sysadm.psapmsgpubhdr
set statusstring = 'CNCLD'
,lastupddttm = to_date(2006010101', 'yyyymmddHH24')
,pubconstatus = 8
where chnlname = 'channel name'
and not statusstring in ('DONE','CNCLD')
;