Can I Tune Db2 for LUW Log Read Performance in Fivetran?

Question

Can I use the SaaS or Hybrid Deployment method to tune Db2 for LUW connection log read chunking, parallelism, or call rate?

Environment

Connector: Db2 for LUW

Answer

No, the Db2 for LUW connector’s log read path is constrained by the IBM Db2 db2ReadLog() behavior. Fivetran doesn't expose settings to tune chunk size, buffer size, prefetch depth, call rate, or parallel log reads for this path. This means:

• Log reading is effectively serial.
• You can't parallelize Db2 for LUW log reads using customer-facing connector settings.
• The Hybrid Deployment method doesn't provide additional tuning options for this limitation.