Topic
No replies
dhivya2010
dhivya2010
2 Posts
ACCEPTED ANSWER

Pinned topic Dump Handler is Processing OutOfMemory exception - during DB migration

‏2012-02-28T14:53:57Z |
We are in the process of migration of data from the existing DB2 database to the target Oracle database using wpsconfig.bat . We have encountered the following error,

java JVMDG217: Dump Handler is Processing OutOfMemory - Please Wait.
java JVMDG315: JVM Requesting Heap dump file
java JVMDG318: Heap dump file written to E:\IBM\Quickr\PortalServer\heapdump.20120227.092618.2788.phd
java JVMDG303: JVM Requesting Java core file
java JVMDG304: Java core file written to E:\IBM\Quickr\PortalServer\javacore.20120227.092621.2788.txt
java JVMDG274: Dump Handler has Processed OutOfMemory.
java JVMST109: Insufficient space in Javaheap to satisfy allocation request
java 02/27/12 09:26:25.774 EST error.executing.transfer
java err.dbtransfer.exception.labelclass com.ibm.db2.jcc.c.DisconnectException: ibmdb2jcct4209111332 Attempt to fully materialize lob data that is too large for the JVM.
java Disable data source property "fullyMaterializeLobData" for locator-based lob implementation.
java com.ibm.db2.jcc.c.DisconnectException: ibmdb2jcct4209111332 Attempt to fully materialize lob data that is too large for the JVM.
java Disable data source property "fullyMaterializeLobData" for locator-based lob implementation.
java at com.ibm.db2.jcc.b.db.zc(db.java(Compiled Code))
java at com.ibm.db2.jcc.b.db.d(db.java(Inlined Compiled Code))
java at com.ibm.db2.jcc.b.eb.a(eb.java(Compiled Code))
java at com.ibm.db2.jcc.b.eb.c(eb.java(Inlined Compiled Code))
java at com.ibm.db2.jcc.b.u.a(u.java(Inlined Compiled Code))
java at com.ibm.db2.jcc.b.j.Ib(j.java(Inlined Compiled Code))
java at com.ibm.db2.jcc.c.bh.Q(bh.java(Inlined Compiled Code))
java at com.ibm.db2.jcc.b.d.g(d.java(Compiled Code))
java at com.ibm.db2.jcc.c.eb.a(eb.java(Compiled Code))
java at com.ibm.db2.jcc.c.bh.c(bh.java(Compiled Code))
java at com.ibm.db2.jcc.c.bh.next(bh.java(Compiled Code))
java at com.ibm.wps.config.db.transfer.DefaultTableHandler.execute(DefaultTableHandler.java(Compiled Code))
java at com.ibm.wps.config.db.transfer.TransferEngine.execute(TransferEngine.java:57)
java at com.ibm.wps.config.db.transfer.CmdLineTransfer.execute(CmdLineTransfer.java:93)
java at com.ibm.wps.config.db.transfer.CmdLineTransfer.main(CmdLineTransfer.java:43)

BUILD FAILED
file:../config/actions/dbt_dbcfg.xml:301: Java returned: 1
_____________________________________________________________________________________________
We have tried the recommendation from the following

http://www-01.ibm.com/support/docview.wss?uid=swg21199311 and increase the ​​-Xmx512m ​​ value from 512M to 1048M which also did not work , please let me know your suggestions