SAP SQL Anywhere

Question

Why is -ha & -ga options and how to turn them off (SQL Anywhere 12.0.1.4178)?

Start line:

...\bin32\dbsrv12.exe -xs http(port=8020) -tq 23:45 -c 15% -os 524288 -z -o "C:\D4w\ASALog_D4w.txt" -cc+ -cr+ -cv+

Log:

I. 07/22 07:25:32. 1: -xs ****
I. 07/22 07:25:32. 3: -tq
I. 07/22 07:25:32. 4: 23:45
I. 07/22 07:25:32. 5: -c
I. 07/22 07:25:32. 6: 15%
I. 07/22 07:25:32. 7: -os
I. 07/22 07:25:32. 8: 524288
I. 07/22 07:25:32. 9: -z
I. 07/22 07:25:32. 10: -o
I. 07/22 07:25:32. 11: C:\D4w\ASALog_D4w.txt
I. 07/22 07:25:32. 12: -cc+
I. 07/22 07:25:32. 13: -cr+
I. 07/22 07:25:32. 14: -cv+
I. 07/22 07:25:32. 15: -ha
I. 07/22 07:25:32. 16: -ga
I. 07/22 07:25:32. 17: -n
I. 07/22 07:25:32. 18: D4w
I. 07/22 07:25:32. 19: C:\D4w\Data\D4w.db
I. 07/22 07:25:32. 20: -n
I. 07/22 07:25:32. 21: d4w
I. 07/22 07:25:32. 22: -hn0,9088:620

Accepted Answer

The -ha switch is an internal switch used when autostarting the server - it tells the server that even though no databases were specified on the command line a database is about to be auto-started. This switch is always added by the client library when a server is being autostarted. There is no need to "disable" it. I.e. without the switch you will not be able to autostart the server/database!

The -ga switch turns on autostop - i.e. when the last database stops then the server automatically stops. This is the default behaviour when a server is autostarted. To "disable" this switch you can specify AUTOSTOP=NO in your connection string.

HTH

SAP SQL Anywhere

-ha & -ga dbsrv12 server option: How to disable?

Follow this question

Related questions