You must mark tables as eligible to participate in incremental transfer. Any table may be so designated, except system tables and worktables. You can designate eligibility either when you create a table, or at a later time by using alter table. You can also use alter table to remove a table’s eligibility.
In eligible tables:
A row is transferred if it has changed since the most recent previous transfer, and if any transactions that changed an existing row—or inserted a new row—were committed before the transfer began.
This requires extra storage for every row, which is implemented by a hidden 8-byte column within the row.
Additional information is kept for each table transfer. This information includes identifying information for the set and number of rows transmitted, the starting and ending times of the transfer, data formatting for the transfer, and the full path to the destination file.
Removing a table’s eligibility removes any per-row changes added to support incremental transfer, and deletes any saved transfer history for that table.
