Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Can these new-school statements (or ones like it)

ALTER MIRROR SERVER xxx12A AS PARTNER log_file = 'C:\xxx\xxx12A.mlog';

ALTER MIRROR SERVER xxx12B AS PARTNER log_file = 'C:\xxx\xxx12B.mlog';

be used to add HA debugging to dbsrv12 engines that were set up with these options?

(or is there some way to add *.mlog files to a 24x7 old-school setup?)

-n xxx12A 
-o "C:\xxx\xxx12ALog.txt" 
-su nfr
-x tcpip(port=55500;dobroadcast=no) 
-xf "C:\xxx\xxx12AState.txt" 
-gl All
-ti 0
"C:\xxx\xxx.db"
-sn xxxPri 
-sm xxxSec
-xp partner=(eng=xxx12B;links=tcpip(host=localhost;port=55599;timeout=2));mode=sync;autofailover=YES;auth=xxx;arbiter=(eng=xxx12;links=tcpip(host=localhost;port=55501;timeout=2))

-n xxx12B 
-o "C:\xxx\xxx12BLog.txt"
-su nfr
-x tcpip(port=55599;dobroadcast=no) 
-xf "C:\xxx\xxx12BState.txt"
-gl All
-ti 0
"C:\xxx\xxx.db"
-sn xxxPri 
-sm xxxSec
-xp partner=(eng=xxx12A;links=tcpip(host=localhost;port=55500;timeout=2));mode=sync;autofailover=YES;auth=xxx;arbiter=(eng=xxx12;links=tcpip(host=localhost;port=55501;timeout=2))

asked 10 Jun '17, 16:14

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

edited 10 Jun '17, 16:16


If you are using the SQL Anywhere 11 compatible -xp, then you can use the logfile=C:\xxx\xxx12A.mlog parameter. For example:

-xp partner=(eng=xxx12B;links=tcpip(host=localhost;port=55599;timeout=2));mode=sync;autofailover=YES;auth=xxx;logfile=C:\xxx\xxx12A.mlog;arbiter=(eng=xxx12;links=tcpip(host=localhost;port=55501;timeout=2))

Mixing -xp and CREATE/ALTER MIRROR server is NOT recommended and can lead to unexpected results.

Kind regards, Ian

permanent link

answered 12 Jun '17, 09:00

Ian%20McHardy's gravatar image

Ian McHardy
3.4k23557
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:

×61

question asked: 10 Jun '17, 16:14

question was seen: 1,701 times

last updated: 12 Jun '17, 09:00