Hello Fivetran,

today all LOADs zu Db2 LUW are setup with the Param "NONRECOVERABLE". But this is are very Risk to loss DATA. In our Environment we setup BLOCKNONLOGGED = YES to prevent this LOADs, because we have to provide a recoverable Database at all time.

This LOAD Param "NONRECOVERABLE" is not Default (LOAD command - IBM Documentation) , the Default "COPY NO" we redirect to "COPY YES". Why do you use this risky param?

NONRECOVERABLE Specifies that the load transaction is to be marked as unrecoverable and that it is not possible to recover it by a subsequent rollforward action. The rollforward utility skips the transaction and marks the table into which data was being loaded as “invalid”. The utility also ignores any subsequent transactions against that table. After the rollforward operation completes, the only supported operations on such a table are:

• Drop the table.
• Restored the table from a backup (full or table space) that was taken after a commit point that follows the completion of the unrecoverable load operation.

To Solve this bad situation, i want a function to set up this LOAD Parameter. Maybe with an Environment Variable or direct as checkbox.

Best Regards,

Michael