Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Hi all,

I'm trying to stop a database server in my mirror system. I connect with Interactive SQL to primary server and execute


I've an error message:

Request start/stop database denied.

I've set the -gk option to ALL.

asked 19 Apr '12, 05:49

snafuz88's gravatar image

accept rate: 0%

You must connect to the database on the server that is acting has primary and have DBA authority on that database in order to force the failover.

Note that the setting of -gk only controls who is allowed to connect to the utility_db on the server. Since you mentioned this I am going to assume that you connected to the utility_db and not the database that you are trying to force a failover.

For reference, here is the documentation section on how to initiate failover.

permanent link

answered 19 Apr '12, 08:35

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Thanks you for your quickly answer.

I've solved this issue. Problem was this:


OPTIONS="-c500m -cl500m -dt/dev/shm -gkALL -gp4096 -n$SERVERNAME -o$LOG -oe$ERRORLOG -susptnkx -ud -x$PROTOCOL"


OPTIONS="-c 500m -cl 500m -dt /dev/shm -gk ALL -gp 4096 -n $SERVERNAME -o $LOG -oe $ERRORLOG -su sptnkx -ud -x $PROTOCOL"

I have seen that nothing happens. I expected that the DB went into read-only mode.

The last sentence of the documentation says that this operation is controlled by the -gk option, that's what I have to specify.

permanent link

answered 19 Apr '12, 10:02

snafuz88's gravatar image

accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 19 Apr '12, 05:49

question was seen: 2,281 times

last updated: 19 Apr '12, 10:02