IBM Support

In InfoSphere Information Server, the command line interface (istool) does not have sufficient memory to run

Troubleshooting


Problem

When you run an istool command, the out of memory error occurs. The issue might occur when you run commands with large amount of data, for example import, export, or query commands.

Symptom

In the following example, the istool query command fails and displays an OutOfMemoryError error in a JAVA heap message:


    istool workbench query -domain myserver -username myname -password mypasswrd -queryname "BI Report Models"

    Initializing query engine .....

    JVMDUMP0061 Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" - please wait.
    JVMDUMP0321 JVM requested Snap dump using '/data/IBM/InformationServer/Clients/istools/cli/Snap.2091125.10000

Cause

By default, the max heap size that is configured for your computer is used. In case of some commands, this amount of memory is not sufficient, and commands fail.

Resolving The Problem

To resolve the issue, use the -Xmx parameter each time you run istool commands with large amount of data. This option specifies the max heap size to use to run the command. The value is the number of megabytes, with no spaces, ending with M to represent megabytes. For example:

export –dom ABC:9443 –username user1 –password pass1 -archive "c:\myarchive.isx" -Xmx1024M –all

In this example, the command sets the max heap size to 1024 MB to export all of the types of assets that are supported by the -all parameter.

Note: The -Xmx parameter increases the heap size temporarily, only as long as the command is run.

[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Information Governance Catalog","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1.2.0;9.1.0.1;9.1;11.5.0.2;11.5.0.1;11.5;11.3.1.2;11.3.1.1;11.3.1.0;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS3GFL","label":"InfoSphere Metadata Workbench"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"9.1;8.7;8.5;8.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
23 June 2018

UID

swg21406714