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