Return
-
Title
What happens to the uncommitted DML sitting in the Post queue if the source database goes down an -
Description
What happens to the uncommitted DML sitting in the Post queue if the source database goes down (crashes) and is recovered whereby those transactions are never committed on source.
 -
Cause
General information.
-
Resolution
In such a situation, the messages in Post queue will remain there forever since there is no COMMIT or ROLLBACK following those messages. The messages need to be manually removed using qview utility. Contact support for assistance in identifying and removing messages from Post queue. It is preferred that such messages be removed as soon as possible since it can be difficult to identify them once the Post queue is inundated with new messages from source once the source database is recovered.
Â