Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Anywhere on virtual server

6 posts in General Discussion (old) Last posting was on 2009-03-16 14:59:38.0Z
Dan Knight Posted on 2009-03-03 14:09:32.0Z
From: Dan Knight <dknight@mullinixpackages.com>
Newsgroups: sybase.public.sqlanywhere
Subject: SQL Anywhere on virtual server
Message-ID: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Mar 2009 06:09:32 -0800
X-Trace: forums-1-dub 1236089372 10.22.241.152 (3 Mar 2009 06:09:32 -0800)
X-Original-Trace: 3 Mar 2009 06:09:32 -0800, vip152.sybase.com
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:255
Article PK: 866696

Are there any issues running SQL Anywhere 8 on a virtual server? Is
there any guidance for this?

Dan


Jeff Albion [Sybase iAnywhere] Posted on 2009-03-03 15:11:51.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: SQL Anywhere on virtual server
References: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
In-Reply-To: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49ad48b7$1@forums-1-dub>
Date: 3 Mar 2009 07:11:51 -0800
X-Trace: forums-1-dub 1236093111 10.22.241.152 (3 Mar 2009 07:11:51 -0800)
X-Original-Trace: 3 Mar 2009 07:11:51 -0800, vip152.sybase.com
Lines: 53
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:256
Article PK: 866697

Dan,

Our statement about VMWare support:
(From: http://search.sybase.com/kbx/solvedcases?id_number=11374712)

"Sybase iAnywhere will support Sybase iAnywhere products running on
VMWare as long as the OS running in the virtual machine is supported by
Sybase iAnywhere. However, if Sybase iAnywhere is unable to reproduce an
issue the customer may be asked to reproduce the problem running
natively on the certified OS, without the use of VMWare. Sybase
iAnywhere does not explicitly test or certify products running in a
VMWare environment."

Dan Knight wrote:
> Are there any issues running SQL Anywhere 8 on a virtual server? Is
> there any guidance for this?

We generally expect it to "work" (we use VMWare to test customer
configurations regularly in technical support), but remember that we are
an application that relies on the OS to execute our system calls
faithfully. When the database server "writes" to the database file, you
have to ensure that your VMWare settings / OS allow for that write to
always make it out to the actual disk. (In some instances, VMWare has
disk-caching enabled by default which means that if you suspend a
session or take an OS snapshot for instance, the write may not propagate
out to disk upon restore...).

This is analogous to our SAN/NAS/iSCSI restrictions of ensuring
write-order and write-through with a network-attached file system:

http://www.sybase.com/detail?id=1034790

This is achieved by ensuring your VMWare disks / disk drivers guarantee
this behaviour as well. Ensure that your disk config (.vmx) has a
property similar to:

ide0:0.writeThrough = "TRUE"

If you're still not sure if this is the case or notice that databases
are corrupting after OS restore/snapshots, you should talk to VMWare
technical support about mechanisms to guarantee that our I/O
requirements are met (between your guest OS / disk drivers / host OS).

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Dietrich [Sybase iAnywhere] Posted on 2009-03-03 15:34:30.0Z
Subject: Re: SQL Anywhere on virtual server
From: "Dietrich [Sybase iAnywhere]" <Dietrich@ianywhere.sybase.germany>
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
References: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
Content-Transfer-Encoding: 7bit
Message-ID: <op.up72vqsm2z78md@dlauterxp>
User-Agent: Opera Mail/9.63 (Win32)
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Mar 2009 07:34:30 -0800
X-Trace: forums-1-dub 1236094470 10.22.241.152 (3 Mar 2009 07:34:30 -0800)
X-Original-Trace: 3 Mar 2009 07:34:30 -0800, vip152.sybase.com
Lines: 33
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:257
Article PK: 866698

Hi,

two cents from my side.

1.) basically having a SQL Anywhere running on a VM guest system is
support. The solved case 11374712 answer that question more accurate:
"Sybase iAnywhere will support Sybase iAnywhere products running on VMWare
as long as the OS running in the virtual machine is supported by Sybase
iAnywhere. However, if Sybase iAnywhere is unable to reproduce an issue
the customer may be asked to reproduce the problem running natively on the
certified OS, without the use of VMWare. Sybase iAnywhere does not
explicitly test or certify products running in a VMWare environment."

2.) Do you know the Technote "Running a SQL Anywhere Database File that is
Stored Remotely from the Server Machine"
(http://www.sybase.com/detail?id=1034790)? The article highlights what
kind of requirements the database engine has on the "hard disk". So, when
SQL Anywhere says "write", it expects that the data is written (on the
hard disk of the virtual server) when the guest OS confirms the writing.


Kind regards,

Dietrich

On Tue, 03 Mar 2009 15:09:32 +0100, Dan Knight

<dknight@mullinixpackages.com> wrote:

> Are there any issues running SQL Anywhere 8 on a virtual server? Is
> there any guidance for this?
>
> Dan


Dan Knight Posted on 2009-03-03 17:27:35.0Z
From: Dan Knight <dknight@mullinixpackages.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Re: SQL Anywhere on virtual server
Message-ID: <b2qqq4dkl303oe2nqfef2cuc4rv83eo6qk@4ax.com>
References: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com> <op.up72vqsm2z78md@dlauterxp>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 3 Mar 2009 09:27:35 -0800
X-Trace: forums-1-dub 1236101255 10.22.241.152 (3 Mar 2009 09:27:35 -0800)
X-Original-Trace: 3 Mar 2009 09:27:35 -0800, vip152.sybase.com
Lines: 45
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:258
Article PK: 866699

Jeff and Dietrich,

Thank you very much for your replies. This should sooth my manager's
fears.

With much appreciation,

Dan

On 3 Mar 2009 07:34:30 -0800, "Dietrich [Sybase iAnywhere]"

<Dietrich@ianywhere.sybase.germany> wrote:

>Hi,
>
>two cents from my side.
>
>1.) basically having a SQL Anywhere running on a VM guest system is
>support. The solved case 11374712 answer that question more accurate:
>"Sybase iAnywhere will support Sybase iAnywhere products running on VMWare
>as long as the OS running in the virtual machine is supported by Sybase
>iAnywhere. However, if Sybase iAnywhere is unable to reproduce an issue
>the customer may be asked to reproduce the problem running natively on the
>certified OS, without the use of VMWare. Sybase iAnywhere does not
>explicitly test or certify products running in a VMWare environment."
>
>2.) Do you know the Technote "Running a SQL Anywhere Database File that is
>Stored Remotely from the Server Machine"
>(http://www.sybase.com/detail?id=1034790)? The article highlights what
>kind of requirements the database engine has on the "hard disk". So, when
>SQL Anywhere says "write", it expects that the data is written (on the
>hard disk of the virtual server) when the guest OS confirms the writing.
>
>
>Kind regards,
>
>Dietrich
>
>On Tue, 03 Mar 2009 15:09:32 +0100, Dan Knight
><dknight@mullinixpackages.com> wrote:
>
>> Are there any issues running SQL Anywhere 8 on a virtual server? Is
>> there any guidance for this?
>>
>> Dan


Markus KARG Posted on 2009-03-16 14:47:13.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
References: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
Subject: Re: SQL Anywhere on virtual server
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49be6671@forums-1-dub>
Date: 16 Mar 2009 06:47:13 -0800
X-Trace: forums-1-dub 1237214833 10.22.241.152 (16 Mar 2009 06:47:13 -0800)
X-Original-Trace: 16 Mar 2009 06:47:13 -0800, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:261
Article PK: 866702

We are running SQL Anywhere 8.0.2 and SQL Anywhere 11.0.0 on VMware Server
2.0 without any problems for years for development and testing purposes.

But two of our customers experienced servere issues with SQL Anyhwere 8.0.2
on VMware Server 2.0 and VMware ESX 3: On VMware ESX 3 they never found out
why the database file was corrupted every other day, so they gave up. On
VMware Server 2.0 the problem was that they tried to run dbvalid while the
database was accessed (after they stopped doing so they did not report
anymore problems) -- what Sybase anyways says that nobody shall do but all
our customers do and have no problems at all unless doing that on VMware
Server 2.0...?! There had been VMware Support and Sybase Support involved,
and both had been very interested but in the end could not say what the
*actual* problem with VMware was.

Regards
Markus

"Dan Knight" <dknight@mullinixpackages.com> schrieb im Newsbeitrag
news:cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com...

> Are there any issues running SQL Anywhere 8 on a virtual server? Is
> there any guidance for this?
>
> Dan


Michael Gould Posted on 2009-03-16 14:59:38.0Z
From: "Michael Gould" <mgould@newsgroupsdummy.com>
Newsgroups: sybase.public.sqlanywhere
References: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
In-Reply-To: <cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com>
Subject: Re: SQL Anywhere on virtual server
Lines: 25
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49be695a@forums-1-dub>
Date: 16 Mar 2009 06:59:38 -0800
X-Trace: forums-1-dub 1237215578 10.22.241.152 (16 Mar 2009 06:59:38 -0800)
X-Original-Trace: 16 Mar 2009 06:59:38 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:262
Article PK: 866705

Dan

Not only do we run VMWare ESX but we also run Citrix. We dedicated one VM
to ASA 9 and found that it wasn't overly stable. We decided to put ASA on a
non-VM machine and we run 5 Citrix VMWare images for the applications and it
is very stable in this mode. I use VMWare for development and testing using
ASA 9 and 11 but those machines are closed at least daily. On ASA under
VMWare we seemed to get a message that showed that it was corrupted but a
stop and start always fixed the issue. We just decided moving to a
non-virutal machine made sense for us and we don't have support issues with
it anymore which in our case was the goal.

Best Regards

Michael Gould

"Dan Knight" <dknight@mullinixpackages.com> wrote in message
news:cdeqq4ldjfketimnpbls43kd8uhbn56f8m@4ax.com...
> Are there any issues running SQL Anywhere 8 on a virtual server? Is
> there any guidance for this?
>
> Dan