For IIAS environment, we need to manually clear out indoubt transactions for each and every partitions irrespective of number of indoubt transactions found.
To Clean indoubt transactions we need go interactive mode by listing indoubt transactions with prompting.
This is a tedious job when we have many partitions and number of indoubt transactions found.
We encountered 28 indoubt transactions per partition in 50 partitions.
We have appliance with 98 partitions as well and it will very inconvenient to clear out if we encounter on that appliance. Hence we need an automated or a script to clean this process.
Why is it useful?
|Who would benefit from this IDEA?||Client|
How should it work?
We need some automation to clearout indobut transactions based on the operation (commit, rollback, etc).
|Priority Justification||We are in transition state from Netezza to IIAS and need this ASAP|
|Customer Name||Blue Shield of CA|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions