Return
-
Title
Is it possible to know in advance how many partial rollbacks are there in the Post queue? -
Description
In the process of troubleshooting and fixing Post issues when encountering partial rollbacks, one may want to know how many of such transactions exist in the queue. This is especially true when certain type of transactions are run on the source database in large numbers, for example, transactions involving ROLLBACK TO SAVEPOINT.
-
Cause
General information.
-
Resolution
There is no way to know in advance how many partial rollbacks exist before deciding to remove them. If qview –p is run to remove those partial rollbacks, then it will certainly point out the subqueues that contain those partial rollbacks, before removing them. However, this will be after the fact.
The above concept also applies to identification of full rollbacks in Post queue.