Saving objects that contain large scripts on systems using a DB2 database cause delays

Document ID : KB000087610
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

After upgrading a DB2 system from Automation Engine (AE) V9 to V11 (up to version 11.1.3), saving objects that contain large scripts can take an extremely long time to save.

Investigation
  1. On an AE V9 using a DB2 database, save an object that contains 20000+ script lines.
  2. It will take a few minutes to save.
  3. ‚ÄčUpgrade the system from AE V9 to AE V11.1.3.
  4. Save the same object that contains 20000+ script lines.
  5. In AE V11.1.3 the same object will take about 30 minutes to save.
Cause:
Cause type:
Defect
Root Cause: In V11.1.4 and 11.1.5 several changes where introduced improving the performance using a DB2 database.
Resolution:
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.

Fix Status: Released

Fix Version(s):
Automation.Engine 11.1.5 - Available
Additional Information:
Workaround :
N/A