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

asked 22 Jul '15, 06:17

Ilia63's gravatar image

Ilia63
736253149
accept rate: 16%


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

permanent link

answered 22 Jul '15, 08:29

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×406

question asked: 22 Jul '15, 06:17

question was seen: 373 times

last updated: 22 Jul '15, 08:29