IBM Support

IV33497: CHANGE JAVA MEMORY SETTING IN $INFOHOME/WEBSQLBR/ADMIN/SPACESQL.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • Users were previously advised to set -mx1024m in spacesql.cfg to
    increase the memory available to the Reporter processes for
    running large reports.
    
    This setting is however too high for generating pdf and gif
    output.
    
    Please change to -mx90m.
    
    The new setting should be:
    
    JAVAPATH=[path to $INFOHOME]/tools/jre/bin/java -ms64m -mx90m
    

Local fix

  • Manually set the value in spacesql.cfg.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All customers who have a headless environment, and create    *
    * reports generating PDF or Images (JPG, GIF).                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Users were previously advised to set -mx1024m in             *
    * spacesql.cfg to                                              *
    * increase the memory available to the Reporter processes for  *
    * running large reports.                                       *
    *                                                              *
    * This setting is however too high for generating pdf and gif  *
    * output.                                                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Set -ms64m -mx90m in                                         *
    *                                                              *
    * $INFOHOME/websqlbr/admin/spacesql.cfg.                       *
    *                                                              *
    * (JAVAPATH=[path to $INFOHOME]/tools/jre/bin/java -ms64m      *
    * -mx90m)                                                      *
    *                                                              *
    * Technote #1516215 amended to reflect this.                   *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IV33497

  • Reported component name

    NC/REPORTER

  • Reported component ID

    5724P9600

  • Reported release

    220

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-17

  • Closed date

    2013-06-19

  • Last modified date

    2013-06-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R220 PSN

       UP

  • R220 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHXS","label":"Tivoli Netcool\/Reporter"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"220","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
19 June 2013