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.

Copying database file, Solaris to Linux

3 posts in General Discussion Last posting was on 2010-06-19 05:49:40.0Z
John Flynn Posted on 2010-06-18 21:34:03.0Z
From: "John Flynn" <jflynn@miqs.com>
Newsgroups: sybase.public.ase.general
Subject: Copying database file, Solaris to Linux
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c1be64b$1@forums-1-dub>
Date: 18 Jun 2010 14:34:03 -0700
X-Trace: forums-1-dub 1276896843 10.22.241.152 (18 Jun 2010 14:34:03 -0700)
X-Original-Trace: 18 Jun 2010 14:34:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29318
Article PK: 78548

Hi.

I have a small database on Solaris, whose database device is one single file
in the filesystem. Periodically I clone this database to other Solaris
machines, and I do it by simply copying the file through the network (after
shutting down both ASEs). I guess what I'm doing is cloning the ASE
instance, master database and all.

The Solaris machines might all be different versions of Solaris, but the ASE
versions are exactly the same on all of them (I upgrade them all in sync,
and I'm up to 15.0.3 ESD#2 now). This has worked perfectly for many years.

Now, I have a Linux box with an AMD processor. I intend to install that
exact same ASE version on it. Can I simply clone the database device which
was born on Solaris, and have ASE on Linux launch it? Is there an issue with
big-endian vs. little-endian? Are Sparc and AMD differently endianned? It
seems that dump-load has solved that cross-platform issue (but maybe not for
the master database?). And if I was using bcp I'd solve it by using
character mode. Can my file-copying technique possibly work?

I guess another way of asking this is... If I were to point a Linux ASE to a
master device that had been created by a Solaris ASE, would it work?

Thanks.
- John.


"Mark A. Parsons" <iron_horse Posted on 2010-06-18 23:43:44.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Copying database file, Solaris to Linux
References: <4c1be64b$1@forums-1-dub>
In-Reply-To: <4c1be64b$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 100606-0, 06/06/2010), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c1c04b0$1@forums-1-dub>
Date: 18 Jun 2010 16:43:44 -0700
X-Trace: forums-1-dub 1276904624 10.22.241.152 (18 Jun 2010 16:43:44 -0700)
X-Original-Trace: 18 Jun 2010 16:43:44 -0700, vip152.sybase.com
Lines: 32
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29319
Article PK: 78552

*flip* ... my coin says it won't work (endian issues) ...

'course, there's always the tried'n'true method ... when it doubt, try it out

John Flynn wrote:
> Hi.
>
> I have a small database on Solaris, whose database device is one single file
> in the filesystem. Periodically I clone this database to other Solaris
> machines, and I do it by simply copying the file through the network (after
> shutting down both ASEs). I guess what I'm doing is cloning the ASE
> instance, master database and all.
>
> The Solaris machines might all be different versions of Solaris, but the ASE
> versions are exactly the same on all of them (I upgrade them all in sync,
> and I'm up to 15.0.3 ESD#2 now). This has worked perfectly for many years.
>
> Now, I have a Linux box with an AMD processor. I intend to install that
> exact same ASE version on it. Can I simply clone the database device which
> was born on Solaris, and have ASE on Linux launch it? Is there an issue with
> big-endian vs. little-endian? Are Sparc and AMD differently endianned? It
> seems that dump-load has solved that cross-platform issue (but maybe not for
> the master database?). And if I was using bcp I'd solve it by using
> character mode. Can my file-copying technique possibly work?
>
> I guess another way of asking this is... If I were to point a Linux ASE to a
> master device that had been created by a Solaris ASE, would it work?
>
> Thanks.
> - John.
>
>


Cory Sane [TeamSybase] Posted on 2010-06-19 05:49:40.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4c1be64b$1@forums-1-dub> <4c1c04b0$1@forums-1-dub>
In-Reply-To: <4c1c04b0$1@forums-1-dub>
Subject: Re: Copying database file, Solaris to Linux
Lines: 44
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18197
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4c1c5a74@forums-1-dub>
Date: 18 Jun 2010 22:49:40 -0700
X-Trace: forums-1-dub 1276926580 10.22.241.152 (18 Jun 2010 22:49:40 -0700)
X-Original-Trace: 18 Jun 2010 22:49:40 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29320
Article PK: 78559

I agree with Mark, endian issues...
Retain your master database and just do the cross server dump loads all of the time...
It will not be as easy as your old method but at least it will work...

I remember the days of only bcp to solve this problem... cross server dump/load is nice when needed.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Mark A. Parsons" <iron_horse@no_spamola.compuserve.com> wrote in message news:4c1c04b0$1@forums-1-dub...
> *flip* ... my coin says it won't work (endian issues) ...
>
> 'course, there's always the tried'n'true method ... when it doubt, try it out
>
> John Flynn wrote:
>> Hi.
>>
>> I have a small database on Solaris, whose database device is one single file
>> in the filesystem. Periodically I clone this database to other Solaris
>> machines, and I do it by simply copying the file through the network (after
>> shutting down both ASEs). I guess what I'm doing is cloning the ASE
>> instance, master database and all.
>>
>> The Solaris machines might all be different versions of Solaris, but the ASE
>> versions are exactly the same on all of them (I upgrade them all in sync,
>> and I'm up to 15.0.3 ESD#2 now). This has worked perfectly for many years.
>>
>> Now, I have a Linux box with an AMD processor. I intend to install that
>> exact same ASE version on it. Can I simply clone the database device which
>> was born on Solaris, and have ASE on Linux launch it? Is there an issue with
>> big-endian vs. little-endian? Are Sparc and AMD differently endianned? It
>> seems that dump-load has solved that cross-platform issue (but maybe not for
>> the master database?). And if I was using bcp I'd solve it by using
>> character mode. Can my file-copying technique possibly work?
>>
>> I guess another way of asking this is... If I were to point a Linux ASE to a
>> master device that had been created by a Solaris ASE, would it work?
>>
>> Thanks.
>> - John.
>>
>>