Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

IBM DB2 10.5, 32 Bit database Java Stored procedure Performance issue

  • 1.  IBM DB2 10.5, 32 Bit database Java Stored procedure Performance issue

    Posted Fri November 13, 2020 10:25 AM
    Hi,

    Thanks in advance. 
    I want the clarification to solve the performance issue while invoke java stored procedure in IBM DB2 10.5, 32 Bit database. 

    Also Let me know, how much java heap size can be set in 32 bit database.
    Recommendations to improve better performance. 
    Below is the log snippet.


    # Changes:
    # 2014-07-16 be im DUMP DSN %Y entfernt wg DSN sonst 45 Char
    # 2013-02-07 be display information about garbage collection etc
    # -verbose:class,gc,jni,sizes,stack
    -verbose:gc,sizes,stack
    # Sets the initial size of middleware heap within non-system heap
    #Xms64M
    -Xms64M
    # Sets the maximum size of nonsystem heap
    #Xmx128M
    -Xmx128M
    # Changes 2013-03-25
    -Xgcpolicy:gencon
    #Xverbosegclog:/tmp/GC.%job.D%y%m%d.T%H%M%S.log
    -Xverbosegclog:/tmp/DB2JAVASTP/DP00/DPA00QZJ/GARBAGE
    -Xdump:system:dsn=P110006.DB2.DPA0.JVM.%job.D%m%d.T%H%M%S
    -Xdump:heap:none
    -Xdump:what
    -Xdump:system:events=systhrow,filter=java/lang/OutOfMemoryError,range=1..1
    -Dorg.slf4j.simpleLogger.logFile="System.out"
    #Dorg.slf4j.simpleLogger.log.com.csc.pts=debug
    -Dorg.slf4j.simpleLogger.log.com.csc.pts=error
    -Dorg.slf4j.simpleLogger.showThreadName=true
    -Dorg.slf4j.simpleLogger.showShortLogName=true
    -Dorg.slf4j.simpleLogger.levelInBrackets=true
    -Dorg.slf4j.simpleLogger.showDateTime=true
    -Dorg.slf4j.simpleLogger.dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss"

    ----------------------
    -Xdump:java:
    events=systhrow,
    filter=java/lang/OutOfMemoryError,
    file=//javacore.%Y%m%d.%H%M%S.%pid.%seq.txt,
    range=1..4,
    priority=400,
    request=exclusive
    ----------------------


    ------------------------------
    Narasimman Balakrishnan
    ------------------------------

    #Db2