High memory usage warning

Hi

I am using build 3060.

I tried to be smart by running explain plan over a script with 250 insert select statements with each a commit to batch check the "executability" of the statements. However, after 486 checks, mentioned dialogue popped up. It shows me the script consuming 646 kB, another open script 19.9 kB and an unsaved tab with 800 B. To that there are a couple of monitor tabs not open with 0 B. The memory consumed in total sums up to 508 of 512 MB. Apparently, the explain tabs opened with the execution consume quite a bit of memory however, none of them is displayed in the tab list. That way it is not possible to close any to free up memory. As the dialogue is modal, so I cannot close any tab the ordinary way.

I feel it unnecessary to have the dialogue modal preventing users from freeing up memory any other way than foreseen by the application.

My workaround was to press the garbage collector button, continue the script and click the hell out of the mouse on the close buttons of the explain plan tabs.

Kind regards

Thiemo

Product: DbVisualizer Pro 110.3060 [Build #3060] [BETA VERSION]
OS: Windows Server 2016
OS Version: 10.0
OS Arch: amd64
Java Version: 1.8.0_172
Java VM: Java HotSpot(TM) 64-Bit Server VM
Java Vendor: Oracle Corporation
Java Home: c:\program files\java\jre8
DbVis Home: C:\ProgramData\DbVisualizer_beta
User Home: C:\Users\kellnerth
PrefsDir: \\tsclient\Q\git\kellnerth\.dbvis_beta
SessionId: 139
BindDir: \[3]
LI: Early Access [2020-03-24] ["BETA version"]
Java Arguments: -prefsdir "\\tsclient\Q\git\kellnerth\.dbvis_beta"
Java Properties:
-Ddbvis.home=C:\ProgramData\DbVisualizer_beta\
-Dexe4j.consoleCodepage=cp0
-Dexe4j.isInstall4j=true
-Dexe4j.moduleName=C:\ProgramData\DbVisualizer_beta\dbvis-multi.exe
-Dexe4j.semaphoreName=Local\c:_programdata_dbvisualizer_beta_dbvis-multi.exe0
-Dexe4j.tempDir=
-Dexe4j.unextractedPosition=0
-Dinstall4j.launcherId=1052
-Dinstall4j.swt=false
-Djava.library.path=c:\program files\java\jre8\bin;C:\ProgramData\DbVisualizer_beta\.\jdbc\jtds\x64\SSO;C:\IBM\InformationServer/jdk32\jre\bin;C:\IBM\InformationServer/jdk32\jre\bin\j9vm;C:\IBM\InformationServer\ASBNode\lib\cpp;C:\IBM\InformationServer\ASBNode\apps\proxy\cpp\vc60\MT_dll\bin;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Oracle_x64\product\12.1.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\ProgramData\chocolatey\bin;C:\Program Files\OpenSSH-Win64;C:\Program Files\Git\cmd;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\Program Files\PowerShell\6\;C:\Program Files\ibm\gsk8\bin;C:\Program Files\ibm\gsk8\lib64;C:\Program Files\PuTTY\;C:\Program Files\TortoiseGit\bin;C:\Program Files\TortoiseSVN\bin;C:\Users\kellnerth\AppData\Local\Programs\Python\Python38\Scripts\;C:\Users\kellnerth\AppData\Local\Programs\Python\Python38\;C:\ProgramData\git-cola\bin;C:\Users\kellnerth\AppData\Local\Microsoft\WindowsApps;C:\Users\kellnerth\AppData\Local\GitHubDesktop\bin
-Doracle.net.tns_admin=Q:\git\kellnerth
-Dsun.locale.formatasdefault=true
-XX:StringTableSize=1000003
-Xmx768m
Look and Feel: SyntheticaGreenDreamLookAndFeel
Keymap: Thiemos (Based on: Default, is Custom keymap)
Screen 1: size: 1920 x 1200, refresh rate: 32, bit depth: 32
Monitor Running: No

*** JVM Options (Application) **********************
-Xmx768m
-XX:StringTableSize=1000003
-Dsun.locale.formatasdefault=true
-include-options ${USERPROFILE}\.dbvis\user.vmoptions



*** JVM Options (User) *****************************
-Doracle.net.tns_admin=Q:\git\kellnerth

*** Database Properties ****************************
Alias: ADW_E1 [UR]
Notes: [0 characters]
Settings Format: Server Info
URL: jdbc:db2://e1-adw-d1:50000/ADW
Driver: DB2
Userid: kellnerth
Preferred Database Type: AUTO
Current Database Type: DB2
Preferred Profile: auto
Current Profile: null (not connected?)
Connection State(s): DISCONNECTED, ERROR
--- Object Type Settings ---------------------------
None
--- Overridden User Properties ---------------------
db2.AutoCommit = false
db2.ConnectionColorBackground = #ccffcc
db2.ConnectionMode = Development
db2.ConnectionModeMigrated = true
db2.SQLCommanderMostRecentSchema = KELLNERTH
db2.SQLCommanderStripComments = true
db2.TextToBinaryEncoding = UTF-8
--- Overridden Driver Properties -------------------
clientProgramName = dbvis
sslTrustStoreLocation = D:\IBM\ADW-E1-001.jks
retrieveMessagesFromServerOnGetMessage = true
defaultIsolationLevel = 1
sslConnection = true
*** End Database Properties ************************
*** Driver Information *****************************
Name: DB2
DefaultDriver: true
DefaultClass: com.ibm.db2.jcc.DB2Driver
Paths:
  Path: C:\ProgramData\DbVisualizer_beta\jdbc\db2\db2jcc4.jar
    Class: com.ibm.db2.jcc.DB2Driver
*** End Driver Information *************************
*** Current Connection Message *********************
An error occurred while establishing the connection:

Long Message:
[jcc][t4][2043][11550][4.25.23] Exception java.io.FileNotFoundException: Error opening socket to server e1-adw-d1/172.16.112.45 on port 50'000 with message: D:\IBM\ADW-E1-001.jks (The system cannot find the file specified). ERRORCODE=-4499, SQLSTATE=08001

Details:
   Type: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException
   Error Code: -4499
   SQL State: 08001

*** End Current Connection Message *****************


*** Database Properties ****************************
Alias: ADW_E2 [UR]
Notes: [0 characters]
Settings Format: Server Info
URL: jdbc:db2://e1-adw-d2:50000/ADW
Driver: DB2
Userid: kellnerth
Preferred Database Type: AUTO
Current Database Type: DB2
Preferred Profile: auto
Current Profile: db2
Connection State(s): CONNECTED
--- Object Type Settings ---------------------------
Schemas/Schema/Tables/Table:
   Label regex ^TC_ETL_OBJECT.*$
--- Overridden User Properties ---------------------
db2.AutoCommit = false
db2.ConnectionColorBackground = #ccffcc
db2.ConnectionMode = Development
db2.ConnectionModeMigrated = true
db2.SQLCommanderMostRecentSchema = KELLNERTH
db2.SQLCommanderStripComments = true
db2.TextToBinaryEncoding = UTF-8
--- Overridden Driver Properties -------------------
clientProgramName = dbvis
sslTrustStoreLocation = D:\IBM\ADW-E1-002.jks
retrieveMessagesFromServerOnGetMessage = true
defaultIsolationLevel = 1
sslConnection = true
*** End Database Properties ************************
*** Driver Information *****************************
Name: DB2
DefaultDriver: true
DefaultClass: com.ibm.db2.jcc.DB2Driver
Paths:
  Path: C:\ProgramData\DbVisualizer_beta\jdbc\db2\db2jcc4.jar
    Class: com.ibm.db2.jcc.DB2Driver
*** End Driver Information *************************
*** Current Connection Message *********************
DB2/LINUXX8664
SQL110111
IBM Data Server Driver for JDBC and SQLJ
4.25.23
*** End Current Connection Message *****************