Improved performance for ROLLBACK TO SAVEPOINT
Db2 11 provides improved performance for the ROLLBACK TO SAVEPOINT statement.
In earlier versions of Db2, the performance of this statement progressively deteriorates with repeated rollbacks to the same external savepoint. This performance degradation is caused by the increasing number of log records that are being scanned each time that the ROLLBACK TO SAVEPOINT statement is issued.
In Db2 11, the ROLLBACK TO SAVEPOINT statement recognizes the point in the log where the previous savepoint finished. This enhancement improves performance by ensuring that subsequent executions of the ROLLBACK TO SAVEPOINT statement scan only the log records that apply to the amount of work to be undone.