Hi,
I am facing the issue while running Jaba Stored procedure in IBM DB2, 10.5, 32 bit database.
How much heap size can be configure maximum for 32 Bit database.
May i know how to increase the performance? to run some more laks of records through stored procedure?
Log:
# 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