Analyze and make necessary modifications to improve SQL batch executions in DB2

• Type: Task
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: None
• Fix Version/s: None
• Component/s: Database Upgrade Framework
• Labels: None
• Epic/Theme:
  • Upgrade-Improvements

DB2 JDBC driver defines autocommit to true by default. With that configuration Java batches using SQL statements are processed one by one as it is explained here:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/java/src/tpc/imjcc_tjvbtupd.html

This affects negatively to the upgrade performance so we have to measure times using autocommit to false at JDBC driver level and make the necessay changes in Java Upgrade framework to support it in case of the performance is better in this way.

The rest of supported databases behave accordingly during batch processors with their default JDBC driver configuration.