Hi team support,
I have query a much data about 100,000 records or more than. I get error that is JVM out of memory, please help me.
The data concern XML(data type is CLOB) that is a big. (Database is DB2)
Question:
1) Can I change maximum JVM size?
2) If I can, please tell me that where it is.
3) I would like to tell you, please add sequence in Object Types where is in Export Schema Script.
Error information:
**An error occurred while executing the database request for:**
**DB2/AIX64**
**SQL09055**
**IBM DB2 JDBC Universal Driver Architecture**
**3.57.82**
**Short message:**
**An error occurred while performing the operation:**
**Virtual Memory Problem! The application is running low on virtual memory. Open Help->Online Resources and choose the FAQ page. It explains how to increase the memory for Java (DbVisualizer).**
**The command that caused the problem:**
**select * from "ESBUSR"."TRANSACTION_LOG"**
**Long Message:**
**Virtual Memory Problem! The application is running low on virtual memory. Open Help->Online Resources and choose the FAQ page. It explains how to increase the memory for Java (DbVisualizer).**
**Details:**
**Type: java.lang.OutOfMemoryError**
***Stack Trace:***
***java.lang.OutOfMemoryError: Virtual Memory Problem! The application is running low on virtual memory. Open Help->Online Resources and choose the FAQ page. It explains how to increase the memory for Java (DbVisualizer).*** **at com.onseven.dbvis.H.B.K.Ă(Z:356)**
**at se.pureit.swing.A.O$1.run(Z:3429)**
**at java.awt.event.InvocationEvent.dispatch(Unknown Source)**
**at java.awt.EventQueue.dispatchEvent(Unknown Source)**
**at com.onseven.dbvis.L.A.V.dispatchEvent(Z:2143)**
**at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEvents(Unknown Source)**
**at java.awt.EventDispatchThread.pumpEvents(Unknown Source)**
**at java.awt.EventDispatchThread.run(Unknown Source)**
