Hello everyone,
We are performing data archiving from a MySQL source via DB2 Federated access.
When we archive the table with a limit of 1,000,000 rows, the job completes successfully in about 10 minutes.
However, when we archive the entire dataset (3,664,153 rows), the job runs for approximately 1 hour and 17 minutes and ends with the following error:

[IBM][CLI Driver][DB2/LINUXX8664] SQL20357N
One or more federated one-phase commit data source sites have failed commit or rollback processing.
As a result, the transaction outcome might not be consistent across all sites.
Subsequent SQL statements can be processed.
Reason code "1".
SQLSTATE=40003

According to the report, the job has successfully archived all rows that we counted from the source

DB2 Version: 11.5.8
MySQL Version: 5.7.44 (Community Edition)

Please help me resolve this issue.

Thanks in advance.