HP-UX, NFS, and C-ISAM
Guy Werry
guy.werry@hbms.ca
Thu, 17 Mar 2005 11:28:19 -0600
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C52B16.B617B8D0
Content-Type: text/plain;
charset="iso-8859-1"
Phil,
We are running Ux 10.2, Ph 7.33.D3 and C-ISAM. Whilst we do not / have not
tried anything with NFS, we have had problems in the past with permissions
on C-ISAM.
We moved over to Ux from MPE and had built an MPE look-alike shell to sit on
top of Unix. This entailed building directories that looked like the old
MPE directory structure, including the idea of "accounts".
Within the accounts we had C-ISAM files set up as Image "databases". So, if
I had a database under MPE named FRED.DATA.PAYROLL, then under Ux we wound
up with a directory/file structure like this:
payroll
data
FRED
c-isam data files
We also found that we had to have the permissions on the c-isam data files
within the FRED directory open to all. (rw-rw-rw-). Otherwise, Powerhouse
choked.
This may not apply to your situation at all, but it's worth checking out.
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.
-----Original Message-----
From: Philip Jackson [mailto:pj@icing-it.org]
Sent: Thursday, March 17, 2005 11:13 AM
To: powerh-l@lists.sowder.com
Subject: HP-UX, NFS, and C-ISAM
Afternoon All,
A question for the unix/PowerHouse boffins out there...
We have two HP-UX boxes, running PowerHouse 8.43.C.
We have mounted one of the directories on box A from box B using NFS.
We can list the contents of the the directory on box A from box B ok, and
read plain subfiles on box A from box B ok, but not indexed subfiles or
indexed data files declared in the dictionary.
Quiz says :-
> go
*E* Data access error. (CT)
*E* Can't use nfs (ISAM 125) (CT)
where CT is the name of an indexed subfile.
Is this because we haven't configured the NFS thing correctly, or is it just
not possibly to access C-ISAM indexed files over NFS in any language? We
were interested to see how PowerHouse was going to handle locking over NFS,
but it may be that we aren't going to get far enough to worry about that.
Any ideas?
Cheers,
Philip
------_=_NextPart_001_01C52B16.B617B8D0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>Phil,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=234422117-17032005>We are
running Ux 10.2, Ph 7.33.D3 and C-ISAM. Whilst we do not / have not tried
anything with NFS, we have had problems in the past with permissions on
C-ISAM.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=234422117-17032005>We
moved over to Ux from MPE and had built an MPE look-alike shell to sit on top of
Unix. This entailed building directories that looked like the old MPE
directory structure, including the idea of "accounts".</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=234422117-17032005>Within
the accounts we had C-ISAM files set up as Image "databases". So, if I had
a database under MPE named FRED.DATA.PAYROLL, then under Ux we wound up with a
directory/file structure like this:</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>payroll</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005> data</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>
FRED</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>
c-isam data files</SPAN></FONT></DIV></BLOCKQUOTE>
<DIV dir=ltr><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>We also found that we had to have the permissions on
the c-isam data files within the FRED directory open to
<STRONG>all</STRONG>. (rw-rw-rw-). Otherwise, Powerhouse
choked. </SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>This may not apply to your situation at all, but it's
worth checking out.</SPAN></FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005></SPAN></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial color=#0000ff size=2><SPAN
class=234422117-17032005>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Philip Jackson
[mailto:pj@icing-it.org]<BR><B>Sent:</B> Thursday, March 17, 2005 11:13
AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> HP-UX, NFS, and
C-ISAM<BR><BR></DIV></FONT>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>Afternoon
All,</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>A question for the
unix/PowerHouse boffins out there...</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>We have two HP-UX
boxes, running PowerHouse 8.43.C.</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>We have mounted
one of the directories on box A from box B using NFS.</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>We can list the
contents of the the directory on box A from box B ok, and read plain subfiles
on box A from box B ok, but not indexed subfiles or indexed data files
declared in the dictionary.</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>Quiz says
:-</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=r_ansi size=2>
<P>> go</P>
<P>*E* Data access error. (CT)</P>
<P>*E* Can't use nfs (ISAM 125) (CT)</P></FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>where CT is the
name of an indexed subfile.</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>Is this because we
haven't configured the NFS thing correctly, or is it just not possibly to
access C-ISAM indexed files over NFS in any language? We were interested to
see how PowerHouse was going to handle locking over NFS, but it may be that we
aren't going to get far enough to worry about that.</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial size=2>Any
ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2>Cheers,</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2>Philip</FONT></SPAN></DIV>
<DIV><SPAN class=245454216-17032005><FONT face=Arial
size=2></FONT></SPAN> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C52B16.B617B8D0--