More efficient point-in-time recovery

In Db2 12, the default behavior for a RECOVER utility job with the TOLOGPOINT option or the TORBA option is to skip unnecessary recoveries. If an object has not been changed since the recovery point, the utility does not recover that object. Therefore, RECOVER can avoid unnecessary work and use fewer resources. This change can also potentially reduce the time that objects are unavailable and improve the overall recovery time.

This new behavior is controlled by the SCOPE option. The default value is SCOPE UPDATE, which specifies that unchanged objects are to be skipped during recovery. However, you can explicitly specify SCOPE ALL to indicate that all objects are to be processed by the RECOVER utility, regardless of whether they have changed since the recovery point.