Once the messages are in the DONE status, it is not possible to resent the messages. What If we need to re submit it?
One option we found is to trigger a SQL update against the table which stores the monitoring data - PSAPMSGPUBHDR
Update PSAPMSGPUBHDR set PUBSTATUS = 1, STATUSSTRING = 'NEW' where IBTRANSACTIONID = ’Transaction ID’ and STATUSSTRING = ‘DONE’
PUBSTATUS values:
0 - Error
1 - New
2 - Started
3 - Working
4 - Done
5 - Retry
6 - Timeout
7 - Edited
8 - Canceled
To monitor the messages, query the appropriate tables with the above status values.
Good One
ReplyDelete