---------------------------- Forwarded with Changes ---------------------------
From: alpha-osf-managers-relay_at_paribas.com
Date: 12/19/95 11:48AM
To: Francois ARCASEDDA at 50
To: Keith MCCABE at 50
*To: Lucien HERCAUD at PB_PARIS
*To: alpha-osf-managers_at_ornl.gov_at_INTERNET at CCROUTER
Subject: SUM + Q: LSM raw volumes and SYBASE
-------------------------------------------------------------------------------
Hi
Many Thanks to Sylvain Gagnons gagnons_at_cae.ca.
I ran the Sybase Backup server as root and the dataserver under
sybase user. The dump-load works well.
Sybase seems to work fine, so far.
Thank you.
Francois ARCA-SEDDA,
Banque Paribas.
-------------------------------------------------------------------------------
Hi, Recently I asked the following:
We are trying to use SYBASE with LSM raw volumes instead of raw
devices
We are using sybinit to create the sybase server. In the "Master
device configuration", if we specify a LSM raw volume
(i.e. /dev/rvol/grpdg/vol_master) instead of a classic device (i.e.
/dev/rrz2d)
we have the following sybase error :
Cannot read file '/dev/rvol/grpdg/vol_master'. Operating system
returned: Not owner.
I have checked the ownership of that file, and the sybase user can
create a file in dev/rvol/grpdg directory.
Sybase user can also read the volume (dd works fine)
Many thanks to
Knut helleboe : knut.hellebo_at_nho.hydro.com who wrote :
I think the sybase user must own all the raw device files for that
volume if this should work (among them also vol_master).
Sam Sarasin : sarasin_at_yosemite.cop.dec.com who wrote:
Make sure that the raw volume is owned by sybase. Also you need to run
voledit and set the owner on the volume or lsm will change the
ownership back to root when you reboot.
Philip Lawrence : philip_at_uvo.dec.com who wrote :
Try setting the permissions with 'voledit set user=sybase group=staff
mode=0666 volXXX'
There are loadsa systems out there running sybase on LSM raw volumes.
Sylvail Gagnons : gagnons_at_cae.ca who wrote :
We get the same problem, according from Sybase you need to ignore this
message during the sybinit, and it should be able to build the master
any way if you have the right file protection.
First, I had already set the protection with voledit. Then I followed
Sylvain advice:
It works OK for sybinit, The database server runs. I succeeded in
creating the database and LOG devices using LSM raw volumes. The
database server seems to work fine EXCEPT for the DUMPS !!!
The Sybase Backup server fails to dump the databases because it fails
to read the LSM raw volume. The error is :
Backup server : 4.56.2.1: Device validation error: couldn't obtain
tape drive characteristics for device /dev/rvol/diskg/vol_data, error:
NOT owner
Msg 8009.level 16,State 1:
The questions are now :
How can we do the sybase dumps ?
Are there any other known problems ?
TIA.
Francois ARCA-SEDDA
Banque Paribas
"Francois ARCASEDDA"_at_paribas.com
--------------- Start RFC822 Headers ---------------
Received: by SMROUTER.PARIBAS.COM (5.65+/1.3)
id 20755.AA; Tue, 19 Dec 95 12:20:38 -0800
Received: from sws1.CTD.ORNL.GOV by flow.pipex.net with SMTP (PP);
Tue, 19 Dec 1995 12:15:35 +0000
Received: (from daemon_at_localhost) by sws1.CTD.ORNL.GOV (8.7.1/8.7.1) id
GAA14824 for aomah; Tue, 19 Dec 1995 06:58:33 -0500
Sender: alpha-osf-managers-relay_at_sws1.ctd.ornl.gov
Followup-To: poster
Precedence: bulk
Received: from oaunx1.ctd.ornl.GOV (oaunx1.ctd.ornl.gov [128.219.128.17]) by
sws1.CTD.ORNL.GOV (8.7.1/8.7.1) with ESMTP id GAA14777 for
<alpha-osf-managers_at_sws1.ctd.ornl.gov>; Tue, 19 Dec 1995 06:55:00 -0500
Received: from mailhost.pipex.net (mailhost.pipex.net [158.43.128.3]) by
oaunx1.ctd.ornl.GOV (8.7.1/8.7.1) with SMTP id GAA11603 for
<alpha-osf-managers_at_ornl.gov>; Tue, 19 Dec 1995 06:54:59 -0500 (EST) Received:
from igwpc1.paribas.com by pipe.pipex.net with SMTP (PP);
Tue, 19 Dec 1995 11:54:13 +0000
Received: from igwpc2.paribas.com by igwpc1.paribas.com id aa24267;
19 Dec 95 10:50 GMT
Received: by SMROUTER.PARIBAS.COM (5.65+/1.3)
id 20735.AC; Tue, 19 Dec 95 11:48:49 -0800
From: "Francois ARCASEDDA"_at_paribas.com
Reply-To: "Francois ARCASEDDA"_at_paribas.com
Message-Id: <9512191948.20735.AC_at_SMROUTER.PARIBAS.COM>
Date: Tue, 19 Dec 95 11:48:00 PST
To: alpha-osf-managers_at_ornl.gov
Subject: SUM + Q: LSM raw volumes and SYBASE
--------------- End RFC822 Headers ---------------
Received on Tue Dec 19 1995 - 18:59:35 NZDT