SQL Anywhere database - What are -ha and -hn0 switches for?

Author

What are -ha and -hn0 switches for?

Breck Carter [TeamSybase]

2005-09-19, 8:24 pm

What are the meanings of the -ha and -hn0,1424:416 on this database
engine command line?

-ha -ga xxx.db -hn0,1424:416

I've seen them before, but they are undocumented options and I can't
remember what people use them for.

Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Joshua Savill

2005-09-19, 8:24 pm

-ga switch unloads the database after last connection is dropped.

Where did you find these switches? The service manager start line?

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:vv4ui1915r9hmvt
gdhvuvut6cn6ra6jcup@
4ax.com...
> What are the meanings of the -ha and -hn0,1424:416 on this database
> engine command line?
>
> -ha -ga xxx.db -hn0,1424:416
>
> I've seen them before, but they are undocumented options and I can't
> remember what people use them for.
>
> Breck
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Glenn Paulley

2005-09-19, 8:24 pm

Some SQL Anywhere command line options are intentionally undocumented,
and these are two of them. In a customer environment, they should only be
used under the direction of iAnywhere technical support staff.

Glenn

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
news:vv4ui1915r9hmvt
gdhvuvut6cn6ra6jcup@
4ax.com:

> What are the meanings of the -ha and -hn0,1424:416 on this database
> engine command line?
>
> -ha -ga xxx.db -hn0,1424:416
>
> I've seen them before, but they are undocumented options and I can't
> remember what people use them for.
>
> Breck
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com RisingRoad SQL Anywhere and MobiLink
> Professional Services www.risingroad.com
>

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Breck Carter [TeamSybase]

2005-09-20, 7:23 am

The client's DBA moved on, leaving little -ha and -hn0 droppings
behind... I'll get them to make another tech support call :)

Breck

On 19 Sep 2005 13:05:50 -0700, Glenn Paulley <paulley@ianywhere.com>
wrote:
[color=darkred]
>Some SQL Anywhere command line options are intentionally undocumented,
>and these are two of them. In a customer environment, they should only be
>used under the direction of iAnywhere technical support staff.
>
>Glenn
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
> news:vv4ui1915r9hmvt
gdhvuvut6cn6ra6jcup@
4ax.com:
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Doug Stone

2005-09-20, 9:23 am

Breck, there's a chapter you missed: Undocumented Switches.
If you ever compile that list, please copy me.
<g>
Doug

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:3smvi15tggmqc3l
lc4352am6nvkfpbpqij@
4ax.com...
> The client's DBA moved on, leaving little -ha and -hn0 droppings
> behind... I'll get them to make another tech support call :)
>
> Breck
>
> On 19 Sep 2005 13:05:50 -0700, Glenn Paulley <paulley@ianywhere.com>
> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-09-20, 8:23 pm

On 20 Sep 2005 06:56:59 -0700, "Doug Stone"
<nospamdstoneatres-qdotcom> wrote:

>Breck, there's a chapter you missed: Undocumented Switches.
>If you ever compile that list, please copy me.
><g>
>Doug

I've got *enough* enemies, thank you very much! <g>

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Ian McHardy

2005-09-21, 9:24 am

They are generated by the client when you autostart a server (for example
with dbspawn, or a connection string with a DBF). -hn and -ha are for
internal use only and should never be specified by the user. One is used to
tell the server where to communicate autostart status to the client, the
other helps with concurrent autostart attempts.

--

Ian McHardy (iAnywhere Solutions)

Please reply only to the newsgroup.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer
"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:vv4ui1915r9hmvt
gdhvuvut6cn6ra6jcup@
4ax.com...
> What are the meanings of the -ha and -hn0,1424:416 on this database
> engine command line?
>
> -ha -ga xxx.db -hn0,1424:416
>
> I've seen them before, but they are undocumented options and I can't
> remember what people use them for.
>
> Breck
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Sponsored Links