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

Problem(Abstract)

In IBM InfoSphere Information Server, enough memory must be allocated to run istool commands.
Insufficient memory allocation in the computer that runs the istool command might cause the command to fail.

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, 64 MB of memory is allocated to run istool commands. This amount of memory is not sufficient to run metadata workbench commands.

Resolving the problem

On the computer where the istool command is run, do these steps to increase memory allocation:

  • In a Microsoft Windows operating system, open IBM\InformationServer\Clients\istools\cli\istool.bat with a text editor and edit this line:
    %JRE%\bin\java -Dlog4j.configuration=logger.properties -jar %PLUGINS%\%LAUNCHER% %COMMANDLINE%

    to be this line:
    %JRE%\bin\java -Xmx2048m -jar %PLUGINS%\%LAUNCHER% %COMMANDLINE%

  • In a UNIX® or Linux operating system, open IBM/InformationServer/Clients/istools/cli/istool with a text editor. Add the line push( @args, "-Xmx2048M"); :

    Original code:
    push( @args, "$JAVA" );
    push( @args, "-jar" );
    push( @args, $LAUNCHER );

    The lines should read:
    push( @args, "$JAVA" );
    push( @args, "-Xmx2048M");
    push( @args, "-jar" );
    push( @args, $LAUNCHER );
    For very large queries in UNIX operating system environments, you might have to allocate several gigabytes of memory. In this case, use a parameter such as -Xmx4g.






Popular posts from this blog

Shrink you container size up to 95%.

alma linux: dnf Module yaml error: Unexpected key in data