Skip to Content
Jan 17, 2018 at 02:08 PM

SQL Anywhere for BI 4 does not start

445 Views Last edit Jan 17, 2018 at 02:09 PM 2 rev

We are having issues with SQL Anywhere starting after using the standard sqlanywhere shutdown script on AIX 7.1. In order to restart, we would need to use the which resolved the problem and restarted everything.

After some in depth research, we found the issue could be resolved by adding the -ch 1g parameter to the SQL Anywhere startup script. However, the server would only restart with 1g, any other number or even using the p resulted in the need to repair the installation. After adding the parameter, we successfully were able to use the shutdown and startup scripts to successfully restart on our DEV & QA servers. We made the same change to our PRD server and had successful results.

We are now getting out of memory errors periodically which shutdown the server and figure it is related to this change. I could remove the parameeter, but that would mean wasting an hour by running the repair to bring the server back up.

We are running SQL Anywhere 12.0.1 build 4127. Are there any other things to try so we can resolve the issue?