SQL Anywhere database - DBStop: how to stop a single Database on a 5.5-server

Author

DBStop: how to stop a single Database on a 5.5-server - command line tools ?

Thomas Auer

2005-10-27, 7:41 am

Hello,

with SQL Central I can stop and start a database("file") on an existing and
running database server. This is no problem for me.

My problem is: how can I make this with command line tools ?
I use the version 5.5.05 and I can only fin the dbstop utility which seems
to stop the hole server instead of a single database running on this server.
I also miss a command line tool to start a database on an existing server
from the client-machine as I can do it from SQL Central.

Is there a way to do this ?

Thanks

Thomas

Ian McHardy

2005-10-27, 7:41 am

STOP DATABASE is only available from isql in 5.5. But you could call isql
from the command line and give it the stop database command. For example

isql -c "uid=dba;pwd=sql" stop database database_name_you_wa
nt_to_stop

Alternatively, you can use the DBLib db_stop_database function to write a C
utility to do this.

--

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
"Dmitri" <NOdimSPAM@mail15.com> wrote in message
news:435e164f@forums
-1-dub...
> Thomas Auer wrote:
>
>
> What's wrong with STOP DATABASE and START DATABASE?
> (I think it is what SC does under the hood)
>
> Dmitri.

Thomas Auer

2005-10-27, 7:41 am

thanks a lot,

I didn't realize this commands

"Ian McHardy" < mchardy_no@spam_iany
where.com> schrieb im Newsbeitrag
news:435e2fc4$1@foru
ms-2-dub...
> STOP DATABASE is only available from isql in 5.5. But you could call isql
> from the command line and give it the stop database command. For example
>
> isql -c "uid=dba;pwd=sql" stop database database_name_you_wa
nt_to_stop
>
> Alternatively, you can use the DBLib db_stop_database function to write a
> C utility to do this.
>
> --
>
> 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
> "Dmitri" <NOdimSPAM@mail15.com> wrote in message
> news:435e164f@forums
-1-dub...
>
>

Sponsored Links