hello:
how the db2 logging work?
for the settings of DATA CAPTURE ,how difference on NONE and CHANGES?
thank you !

"ninth99" <user (AT) compgroups (DOT) net/> wrote

In order to support crash and roll-forward recovery, DB2 needs to write data
to the log files. In this case, DATA CAPTURE can be set to NONE.

However, if you are using SQL Replication (and some other types of
replication like Q-Replication and Change Data Capture) then additional data
needs to be captured in the logs and DATA CAPTURE should be set to CHANGES.