SAP SQL Anywhere

Question

I'm using the ASA 9.02.3951. I'm trying to run a select where the main table has 4301599 lines and within a certain period. And it is with the error "Out of memory". In Interactive SQL and in my Delphi application. I use BDE. alt text

If anyone can help me. Thank you.

Accepted Answer

3

Interactive SQL in 9.0.2 was limited to the default size of Java heap memory, and was limited to a 32-bit process size in total (which is ~1.6 GB on 32-bit Windows, ~3.6GB on 64-bit Windows). Breck's suggestion of using a later version of Interactive SQL would likely help - version 12 and higher uses 1000m as the default heap size.

In version 9, you can try and adjust the Java heap size using the Interactive SQL batch file and see if you can work around this limitation:

Run dbisql -batch - this should produce a file isqlj.bat in the current directory.
Open the batch file in a text editor. Add the following text after 'java.exe':

-Xmx1400m
Run Interactive SQL via the isqlj.bat batch file and try your query again.

permanent link

answered 05 Mar '15, 14:01

Jeff Albion
10.8k●1●71●175
accept rate: 25%

edited 09 Mar '15, 08:55

Not performed. Is presenting the following error message.

Microsoft Windows [versão 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados.

C:\Program Files\Sybase\SQL Anywhere 9\win32>isqlj

C:\Program Files\Sybase\SQL Anywhere 9\win32>C:\PROGRA~1\Sybase\Shared\Sun\jre14
2\bin\java.exe -Dsun.java2d.noddraw=true -Dsun.java2d.d3d=false -Dsqlpath= -Dpat
h=C:\PROGRA~1\Sybase\SQLANY~1\win32;C:\PROGRA~1\Sybase\Shared\Sun\jre142\bin;C:\
PROGRA~3\Oracle\Java\javapath;C:\PROGRA~2\EMBARC~1\Studio\14.0\bin;C:\Users\Publ
ic\DOCUME~1\EMBARC~1\Studio\14.0\Bpl;C:\PROGRA~2\EMBARC~1\Studio\14.0\bin64;C:\U
sers\Public\DOCUME~1\EMBARC~1\Studio\14.0\Bpl\Win64;C:\PROGRA~2\COLLAB~1;C:\PROG
RA~2\EMBARC~1\RADSTU~1\9.0\bin;C:\Users\Public\DOCUME~1\RADSTU~1\9.0\Bpl;C:\PROG
RA~2\EMBARC~1\RADSTU~1\9.0\bin64;C:\Users\Public\DOCUME~1\RADSTU~1\9.0\Bpl\Win64
;C:\PROGRA~2\Borland\Delphi5\Projects\Bpl;C:\PROGRA~2\Borland\vbroker\jre\bin;C:
\PROGRA~2\Borland\vbroker\Bin;C:\PROGRA~2\Borland\Delphi5\Bin;C:\PROGRA~2\Intel\
ICLSCL~1;C:\PROGRA~1\Intel\ICLSCL~1;C:\Windows\SysWOW64;C:\Windows;C:\Windows\Sy
sWOW64\wbem;C:\Windows\SysWOW64\WINDOW~1\v1.0;C:\PROGRA~2\Intel\OPENCL~1\2.0\bin
\x86;C:\PROGRA~2\Intel\OPENCL~1\2.0\bin\x64;C:\PROGRA~1\Intel\INTEL(~1\DAL;C:\PR
OGRA~1\Intel\INTEL(~1\IPT;C:\PROGRA~2\Intel\INTEL(~3\DAL;C:\PROGRA~2\Intel\INTEL
(~3\IPT;C:\PROGRA~2\Sybase\SQLANY~1\drivers;C:\PROGRA~2\Sybase\Shared\SYBASE~1.3
\win32;C:\PROGRA~1\SQLANY~1\Bin64;C:\PROGRA~1\SQLANY~1\Bin32;C:\PROGRA~1\TORTOI~
1\bin;C:\PROGRA~1\MICROS~3\110\DTS\Binn;C:\PROGRA~2\MI3EDC~1\110\Tools\Binn;C:\P
ROGRA~1\MICROS~3\110\Tools\Binn;C:\PROGRA~2\MI3EDC~1\110\Tools\Binn\MANAGE~1;C:\
PROGRA~2\MICROS~1.0\Common7\IDE\PRIVAT~1;C:\PROGRA~2\MI3EDC~1\110\DTS\Binn;C:\MI
CROS~1\bin;C:\PROGRA~1\Sybase\SQLANY~1\x64;C:\PROGRA~1\Sybase\SQLANY~1\win32;C:\
PROGRA~1\Sybase\Shared\win32;C:\PROGRA~1\Sybase\Shared\SYBASE~1.3\win32 -Disql.h
elpFolder=C:\PROGRA~1\Sybase\SQLANY~1\java -Dasa.location=C:\PROGRA~1\Sybase\SQL
ANY~1\ -Dsybase.jsyblib.dll.location=C:\PROGRA~1\Sybase\Shared\win32\ -Disql.com
mandShell="C:\Windows\SysWOW64\cmd.exe /c"  -classpath C:\PROGRA~1\Sybase\SQLANY
~1\java\isql.jar;C:\PROGRA~1\Sybase\Shared\JCONNE~1\classes\jconn2.jar;C:\PROGRA
~1\Sybase\SQLANY~1\java\jlogon.jar;C:\PROGRA~1\Sybase\SQLANY~1\java\jodbc.jar;C:
\PROGRA~1\Sybase\Shared\java\SCEDIT~1.JAR;C:\PROGRA~1\Sybase\Shared\java\JCOMPO~
1.JAR;C:\PROGRA~1\Sybase\Shared\java\JSYBLI~1.JAR;C:\PROGRA~1\Sybase\Shared\Sun\
JAVAHE~1\jh.jar;C:\PROGRA~1\Sybase\Shared\java\HELPMA~1.JAR;C:\PROGRA~1\Sybase\S
QLANY~1\java\xerces.jar;C:\PROGRA~1\Sybase\SQLANY~1\java\xml4j.jar; sybase.isql.
isql -locale en -Xmx1400m
Error! Unknown command line option "-Xmx1400m"
Adaptive Server Anywhere Interactive SQL Version 9.0.2.3951
Usage: DBISQL [options] [sqlCommand|commandFileName]

   Options:
    -c "keyword=value;..."        Database connection parameters
    -codepage <codepage>          Use this codepage when reading/writing files
    -d "delimiter"                Use the given string as the command delimiter
    -d1                           Print statements as they are executed
                                    (command-line mode only)
    -dataSource <DSN>             ODBC data source name
    -f <filename>                 Open the given file for editing
    -host <address>               Network address of the database server
    -jConnect                     Connect using jConnect
    -nogui                        Run in command-line mode
    -ODBC                         Connect using ODBC (default)
    -onerror {continue|exit}      Override ON_ERROR option for all users
    -port <portNumber>            TCP/IP port number of the database server
    -q                            Suppress non-critical messages
    -x                            Check SQL syntax but do not execute


C:\Program Files\Sybase\SQL Anywhere 9\win32>

(06 Mar '15, 12:55) Walmir Taques

Replies hidden

Comment Text Removed

My apologies - the instructions should say to add the "-Xmx 1400m" switch just after "java.exe" - it's a switch to the JVM.

(09 Mar '15, 08:54) Jeff Albion

flat view

SAP SQL Anywhere

Out of memory

Follow this question

Related questions