PowerExchange for Amazon Redshift User Guide for PowerCenter

Back Next

Configure the Java Heap Memory

When the source or target contains a large amount of data, configure the memory for the Java heap size on the node that runs the PowerCenter Integration Service. You must ensure that the minimum physical memory available on the server machine for each session is in the range of 300 to 500 MB.

You must set a maximum heap size value based on the amount of data that you want to process.

In the Administrator tool, navigate to the PowerCenter Integration Service for which you want to change the Java heap size.

On the

Processes

tab, edit the

General Properties

section.

Specify the maximum heap size in Java SDK Maximum Memory limit based on the amount of data you want to process.

The default value of the maximum heap size is 64 MB and the minimum size is 32 MB.

Click

Recycle the PowerCenter Integration Service.

PowerExchange for Amazon Redshift Configuration