1.5 First steps towards Configuring

 Aqua Data Studio uses a new Windows launcher. The executable is datastudio.exe, which uses datastudio.ini for the configuration settings.  Below is a list of parameter and options that may be used in the datastudio.ini for configuring Aqua Data Studio.

An example and default INI file for Aqua Data Studio:

# JVM Properties
vm.location=.\jre\bin\client\jvm.dll

# Specify a proportion of the available physical memory to use (ie. relates to -Xmx arg). 
# For example, vm.heapsize.max.percent=75. Note that this will use the maximum memory possible.
#vm.heapsize.max.percent=
# Specify a proportion of the available physical memory to use as the minimum 
# starting heap size (ie. relates to -Xms arg).
#vm.heapsize.min.percent=

# Specify a preferred amount (in MB) for the heap size (ie. relates to -Xmx arg). If this amount
# is not available it will use the maximum amount possible given the physical memory available.
#vm.heapsize.preferred=

# Specifies that only one instance of the product should run at any given time
single.instance=window

vmarg.1=-Dsun.swing.enableImprovedDragGesture
vmarg.2=-Xmx256M
vmarg.3=-Di18n.test.mode=1

classpath.1=.\lib\*.jar
classpath.2=.\lib\drivers\*.jar
classpath.3=.\lib\jide\*.jar
classpath.4=.\lib\jinterop\*.jar
classpath.5=.\lib\ssh2\*.jar
classpath.6=.\lib\nb\*.jar
classpath.7=.\lib\nb\eapi\*.jar
classpath.8=.\lib\nb\mlkup\*.jar
classpath.9=.\lib\nb\msc\*.jar
classpath.10=.\lib\nb\pcore\*.jar
classpath.11=.\lib\nb\ql\*.jar
classpath.12=.\lib\nb\tc\*.jar
classpath.13=.\lib\nb\v\*.jar
classpath.14=.\lib\nb\vapi\*.jar
classpath.15=.\lib\nb\xed\*.jar
classpath.16=.\lib\nb\gsf\*.jar

main.class=com.aquafold.datastudio.DataStudio
 

Memory Configuration

Querying for large resultsets may cause ADS to run out of memory or to run low on memory. The user may need to increase memory limit for Aqua Data Studio and restart the application. As a Java application, Aqua Data Studio is limited to the memory allocated to the JVM at startup. You may change your setting according to the Operating System you are working on.

• 
  Windows
• Windows EXE execution and Windows Launcher -- In your installation directory (default: "C:\Program Files\Aqua Data Studio") there is a file called datastudio.ini which contains JVM parameters for startup. In this file you may modify the line "vmarg.2=-Xmx256M", where ’256’ is equal to the amount of memory allocated to Aqua Data Studio. You can change this number to increase your memory to 512MB, 1024MB or larger. Once you have made your changes, restart Aqua Data Studio.
  
  
  
• Windows .bat execution In your installation directory there are two files called datastudio-bundled.bat and datastudio.bat which are used to start Aqua Data Studio. In either of these files modify the last line which starts with "java -cp ..." or ".\jre\bin\java -Xmx256M ...", where ’256’ is equal to the amount of memory allocated to Aqua Data Studio. You can change this number to increase your memory to 512MB, 1024MB or larger. Or add the option if it doesn’t exist. Once you have made your changes, restart Aqua Data Studio.
• 
  Linux
• Linux Application In your installation directory there are two files called datastudio-bundled.sh and datastudio.sh which are used to start Aqua Data Studio. In either of these files modify the last line which starts with "java -cp ..." or ".\jre\bin\java -Xmx256M ...", where ’256’ is equal to the amount of memory allocated to Aqua Data Studio. You can change this number to increase your memory to 512MB, 1024MB or larger. Or add the option if it doesn’t exist. Once you have made your changes, restart Aqua Data Studio.
• 
  OSX
• OSX Double Clickable Application The OSX double-clickable application is actually a directory structure with an extension of ".app". You may modify the files in this directory structure by right-clicking on the Aqua Data Studio icon and selecting "Show Package Contents" where you can browse to edit Contents/Info.plist with TextEdit. This file is an XML file containing startup parameters for Aqua Data Studio. To change or increase the memory add the following XML tags in the tags right before the MainClass where ’256’ is the amount of memory you want for Aqua Data Studio. Example ...

•     ...   
  
          VMOptions
  
          -Xmx256m
  
          MainClass
  
          com.aquafold.datastudio.DataStudio
  
          JVMVersion
  
          1.5+
  
      ...
  
  
  
  

   

• OSX Unix Application In your installation directory there is a file called datastudio.sh which is used to start Aqua Data Studio. In this file modify the last line which starts with "java -cp ...", where ’256’ is equal to the amount of memory allocated to Aqua Data Studio. You can change this number to increase your memory to 512MB, 1024MB or larger. Or add the option if it doesn’t exist. Once you have made your changes, restart Aqua Data Studio.

Viewing Aqua Data Studio’s current RAM usage
You can quickly view how much of your JVM’s RAM is being used by Aqua Data Studio by looking at the bottom right corner of the Main Application window in the Heap Size Display, next to the Garbage Collection icon which is a tiny trashcan.

The current RAM used by Aqua Data Studio is displayed on the left in megabytes.

The JVM’s allocated RAM is displayed to the right in megabytes.

A yellow bar and vertical line indicate graphically what percentage of the JVM’s RAM is currently being used by Aqua Data Studio.

Clicking on the trash can performs garbage collection, freeing up more of the JVM’s allocated RAM for Aqua Data Studio to use.