The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi there,

i am new to SQL Anywhere and i hope you can help me:

we are using SQL Anywhere 12.0 und try to setup a test mirroring (see Sybase/SAP tutorial). When i want to define the primary and secondary server, i get following error message:

"The database mirroring options are not supported for this database"... SQLCODE= -1307, ODBC 3 state = HY000

Can somebody tell me what does it mean? I can't find more information in the internet.

Thanks and best regards from germany Sabrina

asked 26 Feb '15, 04:05

sabstar's gravatar image

sabstar
76449
accept rate: 0%


The docs do tell the following for that error message:

The current database does not have catalog support for database mirroring servers and options. To use this feature, upgrade your database to the most recent version.

So I would conclude that you are using v12 but the database has been created with an earlier version and therefore has to be upgraded (via DBUPGRAD) or - better - reloaded.

You can use "select * from syshistory" to find out about the database file version.

permanent link

answered 26 Feb '15, 04:52

Volker%20Barth's gravatar image

Volker Barth
29.3k287438644
accept rate: 32%

edited 26 Feb '15, 04:52

Thanks for your answer!

I used your query and got 3 rows:

Operation Version INIT 11.0.1.2044 LAST_START 12.0.0.2483 START 12.0.0.2483

Does it mean, that my db is allready runnig as v12? How do i use DBUGRAD?

Thanks and regards, Sabrina

(26 Feb '15, 05:00) sabstar
Replies hidden
1

The INIT row does tell the database has been created with v11 and has not been upgraded since.

Note: Both v11.0.2044 and 12.0.0.2483 are very old builds of v11 and v12 (the original GA releases, IIRC) so you are missing hundreds of bug fixes and enhancements. When doing tests I would very stronlgy recommend to use a new build of v12.0.1 (or v16), and particulary for tests with mirroring.

Furthermore, I would also recommend to do a full reload with the newest version instead of DBUPGRAD.

(26 Feb '15, 06:19) Volker Barth
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:

×79
×26

question asked: 26 Feb '15, 04:05

question was seen: 374 times

last updated: 26 Feb '15, 06:33