Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Data Integration performance tuning overview
  3. Optimizing targets
  4. Optimizing sources
  5. Optimizing mappings
  6. Optimizing mapping tasks
  7. Optimizing advanced clusters
  8. Optimizing system performance

Data Integration Performance Tuning

Data Integration Performance Tuning

INFA_MEMORY and JVM options

INFA_MEMORY and JVM options

You can configure the INFA_MEMORY property and JVM options to achieve optimal performance and avoid Java heap and memory-related errors. Define these properties on the agent details page in Administrator.
You can configure the INFA_MEMORY and JVM options using the following formats for values:
Format
Description
-Xms**m
The initial amount of memory allocated to the JVM when the Java process starts.
Since this is the initial value, the Xms value can be small, for example, 64m or 128m. The Java process will allocate more space as required.
-Xmx****m
The maximum amount of memory that the JVM can allocate as heap. After the Java process starts, it will continue to allocate space to store its objects. The allocation can continue until the maximum setting is reached.
Set the value to be large enough to hold all the Java objects and classes. On a 64-bit agent, the value can be about 1024M or 2048M.
-XX:MaxPermSize=***m
The maximum amount of permanent space that the JVM can use at a time. If the JVM needs more than the specified amount, the Java process fails.
You can set this value to an average of 512M. However, the value must be less than the -Xmx value. Increase the MaxPermSize value if you receive an error about permGen space.

INFA_MEMORY

Define the INFA_MEMORY property on the agent details page in the
System Configuration Details
section. Select the Data Integration Service and the Tomcat JRE type, then define the INFA_MEMORY property.
The following image shows the INFA_MEMORY property on the agent details page:
 The System Configuration Details section of the agent details page shows the INFA_MEMORY property with the value -Xms32m -Xmx512m.

JVM options

Define JVM options on the agent details page in the
System Configuration Details
section. Select the Data Integration Service and the DTM type, then define a JVMOption property.
Each JVMOption property can include one JVM attribute. You can define up to five JVMOption properties. If you already have five JVMOption properties, you can create more as a custom property.
The -Xmx property determines the heap size. The default value is 64MB. For mappings that process large data volumes with multiple partitions, the default value can cause mapping failure because of insufficient Java heap space. The recommended value for this property is 2024MB.
The following image shows configuration for the JVMOption1 property on the agent details page:
 The System Configuration Details section of the agent details page shows the JVMOption1 property with the value '-Xmx2024m'.

0 COMMENTS

We’d like to hear from you!