Home Home Screenshots Download Documentation Contact Licensing Licensing

Documentation: Aqua Data Studio 6.0 - New Features     HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)
  Getting Started
  Installation
  JDBC Drivers
  I. Oracle
  II. DB2 UDB
  III. SQL Server
  IV. Sybase ASE
  V. Sybase Anywhere
  VI. Sybase IQ
  VII. Informix
  VIII. PostgreSQL
  IX. MySQL
  Memory Configuration
  Character sets
  Registering Servers
  I. MSDE 2000
  II. SQL Express 2005
  III. PostgreSQL SSL
  Application
  I. Browser and Scripting
  II. Visual Editing
  III. SQL History
  IV. Shortcut Toolbar
  V. Key Mappings
  VI. Custom Keymap Profiles
  VII. Options
  VIII. Settings
  Query Window
  I. Basics
  II. Toolbar
  III. Server Side Comments
  IV. SQL Automation
  V. Variable Binding
  VI. Results
  VII. Save Results
  VIII. Auto-completion
  IX. SQL Formatter
  X. Permissions
  XI. Parameterized
  Editors
  I. SQL Editor
  II. Text Editor
  III. HTML Editor
  IV. XML Editor
  V. Regular Expressions
  Image Viewer
  Visual Explain Plan
  I. Basics
  II. Explain Plan
  III. Explain Diagram
  IV. Whiteboard
  Procedure/Package Editor
  Tools
  I. Table Data Editor
  II. Script Generator
  III. ER Diagram
  IV. Query Builder
  V. Import Tool
  VI. Export Tool
  VII. Execution Monitor
  Difference Tools
  I. Schema Diff
  II. Tab Diff
  III. Directory Diff
  IV. File Diff
  V. Copy History Diff
  Oracle DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Rollback Manager
  IV. Log Manager
  V. Security Manager
  VI. Session Manager
  VII. SGA Manager
  VIII. Server Statistics
  SQL Server DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager
  V. SQL Agent Manager
  Sybase DBA Tools
  I. Instance Manager
  II. Storage Manager
  III. Security Manager
  IV. Session Manager

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 In your installation directory (default: "C:\Program Files\Aqua Data Studio") there is a file called datastudio.cfg which contains JVM parameters for startup. In this file you may modify the 3rd line which starts with "-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.4+
    ...

  • 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.

Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved