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.

Hello, Has anyone had a problem with SA12 ( freezes when running a database that was created with SA11? The database has not been rebuilt, and as far as I understand, it doesn't need to be rebuilt according to (see Upgrading to SQL Anywhere 12). The database works well and sometimes mystical freezes occur (once or twice an hour) - it seems like the database server is doing something internally, and nothing (or very slow) can be done (from several seconds to several minutes). Is there any other option than rebuild?

asked 27 Jul '11, 07:17

Arthoor's gravatar image

accept rate: 11%

edited 27 Jul '11, 09:07

Please show us exactly where you read that "it must not be rebuilt"... you can find specific pages online here instead of referring to a PDF.

(27 Jul '11, 08:42) Breck Carter
Replies hidden

Foxhound might help you find the cause, or perhaps a clue to the cause.

(27 Jul '11, 08:45) Breck Carter says:

"If you are upgrading from version 10 or later, you can either upgrade or rebuild your database. Upgrading or rebuilding is an optional step because the version 12 software can be used with a version 10 or later database. However, if you want to take advantage of all the new features in version 12, you must rebuild your database."

So if we do not want to take advantage of all the new features it should be enough to just start an old database on SA12 server without migration or rebuild. We want to firstly make sure that SA12 has no problems with our software and then (and only then) rebuild.

(27 Jul '11, 08:56) Arthoor

Thanks for the clarification. I think we are confused by your use of "must not be" - what you mean is that it "doesn't need to be" which is correct; a 12.0.x server can run/use a database that has been built by v10.0.x or v11.0.x

(27 Jul '11, 09:04) Mark Culp

Sorry, my English is not good enough. I have corrected the description of this topic.

(27 Jul '11, 09:08) Arthoor

Platform? Windows? Version of OS? When the server "freezes" how much CPU is the server using? How much IO?

Check the server console log to see if there is a checkpoint running at the time that the server "freezes" - it could be that the server is in the process of flushing all dirty pages from the cache in preparation for a checkpoint?

permanent link

answered 27 Jul '11, 08:24

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

Windows 2008 R2 64bit, 2 CPU. It is the same server on which the same database was running with SA11 before without problems. IO on freeze: average 15, max 150 IOPS. CPU use: 30 to 50 percent. There are no suspicious changes (gaps in time) in the console log when checkpoints are being done. I mean that checkpoint has no influence to the speed of other operations.

(27 Jul '11, 09:38) Arthoor
Replies hidden

From Volker and Breck came this advice for a different question:

"I fully agree that dbsrvX -o (possibly with its variants -oX) should be using on every production server to help diagnosis.

(Jan 22 at 18:56)Volker Barth

Further to what Tyson and Volker said: -o filespec1.txt -oe filespec2.txt -os 1M is a good combination for production. The -os 1M keeps the file size manageable for browsing with Wordpad etcetera. For a service the filespecs probably have to have the full path. "

(27 Jul '11, 10:00) Martin

-o is always being used but I do not see anything suspicious in the .slg file.

(28 Jul '11, 03:10) Arthoor
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: 27 Jul '11, 07:17

question was seen: 2,193 times

last updated: 28 Jul '11, 03:22