Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-93363

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

    Details

    • Type: Task
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            support-lep@liferay.com SE Support
            Reporter:
            alberto.chaparro Alberto Chaparro
            Recent user:
            Marta Elicegui
            Participants of an Issue:
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Packages

                Version Package