Increase the PDI client memory limit
We recommend that you increase PDI's memory limit so the Pentaho Server and the PDI client (Spoon) can perform memory-intensive tasks, like process or sort large datasets or run complex transformations and jobs. You will need to increase the memory limit for both the Pentaho Server and the PDI client. If you choose to not increase the memory limit, PDI uses the default memory settings that are defined in your startup scripts.
Modify the PDI client startup script
Procedure
Exit from the PDI client if it is currently running.
Open the PDI client startup script with a text editor. The name of startup script depends on your operating system.
- Windows Name and Location of Startup Script: pentaho/design-tools/data-integration/Spoon.bat
- Linux Name and Location of Startup Script: pentaho/design-tools/data-integration/Spoon.sh
Modify the -Xmx value so that it specifies a larger upper memory limit.
In this example, 2g (two gigabytes) of heap space has been allocated.PENTAHO_DI_JAVA_OPTIONS="-Xmx2g -XX:MaxPermSize=256m"
Save and close the startup file.
Start the PDI client and ensure that there are no memory-related errors.
If you see an error, repeat these steps to increase the memory again.
Results
Next steps