SQL Anywhere database - How could I pause SQL remote?

Author

How could I pause SQL remote?

Joanna

2005-04-19, 7:23 am

Hi all,

I have set up one consolidated database and 2 remote databases, and I have
started the SQL remote in continuous mode.
There is a process (say process A) which is easily failed when it is not
properly set up before running, Therefore, I do a backup on the consolidated
database, shutdown all SQL remotes (by clicking the Shutdown button) and run
process A.
If process A completed successfully, I can then restart all SQL remotes and
the changes made during process A can be replicated to those remote
databases. But if process A failed, I only have to restore the consolidated
database as the remote databases is not modified with the SQL remote
shutdown.

Now my problem is, how to automate this shutdown and restart process of SQL
remote? I'm using ASA 7.03. Thanks in advance.

--
Regards,
Joanna Wan

Rob Waywell

2005-04-19, 7:23 am

If you are running dbremote as a service, then you can do a net stop on the
service to shut it down.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

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

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

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

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Joanna" <joanna.wan@caplogic.com> wrote in message
news:4264e6f1$1@foru
ms-2-dub...
> Hi all,
>
> I have set up one consolidated database and 2 remote databases, and I have
> started the SQL remote in continuous mode.
> There is a process (say process A) which is easily failed when it is not
> properly set up before running, Therefore, I do a backup on the
consolidated
> database, shutdown all SQL remotes (by clicking the Shutdown button) and
run
> process A.
> If process A completed successfully, I can then restart all SQL remotes
and
> the changes made during process A can be replicated to those remote
> databases. But if process A failed, I only have to restore the
consolidated
> database as the remote databases is not modified with the SQL remote
> shutdown.
>
> Now my problem is, how to automate this shutdown and restart process of
SQL
> remote? I'm using ASA 7.03. Thanks in advance.
>
> --
> Regards,
> Joanna Wan
>
>

Joanna

2005-04-20, 7:23 am

If I run dbremote as a service, then I have to disclose the password of dba
in the parameter needed to run dbremote. How can I avoid disclosing the
password?

--
Regards,
Joanna

"Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
news:4264f842$1@foru
ms-2-dub...
> If you are running dbremote as a service, then you can do a net stop on
> the
> service to shut it down.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
> "Joanna" <joanna.wan@caplogic.com> wrote in message
> news:4264e6f1$1@foru
ms-2-dub...
> consolidated
> run
> and
> consolidated
> SQL
>
>

Rob Waywell

2005-04-20, 7:23 am

You don't need to use a DBA user to run dbremote:

ASA SQL Reference

SQL Statements

GRANT REMOTE DBA statement [SQL Remote]

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

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

To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug

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

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer
"Joanna" <joanna.wan@caplogic.com> wrote in message
news:4266175c$1@foru
ms-2-dub...
> If I run dbremote as a service, then I have to disclose the password of
dba
> in the parameter needed to run dbremote. How can I avoid disclosing the
> password?
>
> --
> Regards,
> Joanna
>
> "Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
> news:4264f842$1@foru
ms-2-dub...
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug[color=darkred]
not[color=darkred]
and[color=darkred]
>
>

Joanna

2005-04-20, 8:23 pm

Thanks for your reply! I think I know how to do.

--
Regards,
Joanna

"Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
news:42664b1c$1@foru
ms-1-dub...
> You don't need to use a DBA user to run dbremote:
>
> ASA SQL Reference
>
> SQL Statements
>
> GRANT REMOTE DBA statement [SQL Remote]
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
> "Joanna" <joanna.wan@caplogic.com> wrote in message
> news:4266175c$1@foru
ms-2-dub...
> dba
> http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
> not
> and
>
>

Sponsored Links