cancel
Showing results for 
Search instead for 
Did you mean: 

Memory error message in DBISQL

Former Member
9,507

when I launch dbisql (SQLA V10.0.1.3706), if I type any key I have the message "Error! There is not enough memory to add the text" as I have enough memory on my computer.

But if I launch Sybase Central, connect to the data base, then launch dbisql with "Open interactive SQL" by right click on the data base name, then functioning is correct.

Do you have any idea on that error message ?

Denelbe

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

When you get that message, it means that DBISQL has exhausted its memory heap. DBISQL 10.0.1 has a fixed maximum heap size, which is around 64M. Sybase Central 5.0.0 has a higher limit (200M), which is why launching DBISQL from Sybase Central can fix the problem.

You can run DBISQL with a 200M heap by "-Xmx200M" on the DBISQL command line.

You can also configure DBISQL to always use up to 200M by creating a registry key called

HKLM\\SOFTWARE\\Sybase\\SQL Anywhere\\10.0\\DBISQL\\VMArgs

In that key, add a string value called "-Xmx200M". It doesn't matter what data value you give it. Now, whenever you run DBISQL, it will use up to a 200M heap.

Note that if you are running DBISQL 10.0.1 on a 64-bit machine, the registry key entry location is slightly different:

HKLM\\SOFTWARE\\Wow6432Node\\Sybase\\SQL Anywhere\\10.0\\DBISQL\\VMArgs

-- Chris Irie [Sybase]

Answers (2)

Answers (2)

Former Member
0 Kudos

Ok. I found it!!

For anyone who have the same problem, here is how it can be fixed.

Run "dbisql" command with the "-batch" parameter. This will create a script that executes dbisql, but you can modify the "-Xmx" para meter inside.

Edit the "dbisql.sh" generated and change the value of -Xmx parameter of the JVM to "200m" and that's it.

See ya!

Former Member
0 Kudos

Where can I put that parameter if I'm running DBISQL on a Linux 64bits machine??

I found once a script to do it, but I can't find it anymore.

Could you help me?