RE: NFS mount

[Mike Cunningham <mike.cunningham@xxxxxxx>]

An NFS mount of the Windows server with MS SQL installed would not let you access an individual table inside an MS SQL schema. Individual tables in MS SQL are not individual OS objects as they are in DB2 for i.  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Saturday, June 01, 2013 11:39 PM
To: Midrange Systems Technical Discussion
Subject: Re: NFS mount

Windows has been able to do both client and server NFS for years - it's all in a package called Unix Services or some name like that.

Roger gave the link to an RJS page - there are a number of articles there, and many RJS customers have used NFS for storing documents that its Webdocs product serves.

That's not a product endorsement - just happens to be a recommended remote file system - QNTC is much more painful to deal with, generally.

Regards
Vern

On 6/1/2013 9:31 PM, Mark S Waterbury wrote:
> Hi, Roger:
>
> Thanks for that update -- glad to hear it -- it's about time ... shows 
> my knowloedge of Windows is out-dated ...
>
> Mark
>
>   > On 6/1/2013 9:41 PM, Roger Harman wrote:
> > According to Microsoft, Server 2008R2 supports both client and server 
> > roles for NFS.
> > http://technet.microsoft.com/en-us/library/dd758767(v=ws.10).aspx
> >
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S 
> > Waterbury
> > Sent: Saturday, June 01, 2013 6:05 PM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: NFS mount
> >
> > Windows does not support NFS "out of the box".  You would have to buy 
> > some NFS software for Windows and install it, or find suitable NFS 
> > freeware, shareware or "open source" equivalent, and install and use that.
> >
> >    > On 6/1/2013 8:56 PM, Peter Connell wrote:
> > > I want to load a file in a database on SQL Server 2008 R2 using SQL 
> > > bulk
> > insert from a csv file.
> > > So that I can use the IFS on the i5 I would like to mount the SQL 
> > > server
> > using the MOUNT command but need some advice as this is new to me.
> > > The MOUNT cmd  has the format MOUNT TYPE(*NFS) MFS(?????)
> > > MNTOVRDIR(??????) and I need to know what to specify for MFS and 
> > > MNTOVRDIR
> > >
> > > The host name of the SQL Server box is nzaklgl-db601.corp.bayadv 
> > > which can be pinged from the i5 and returns an IP address of 
> > > 10.9.64.65 If I log on to the SQL Server machine and look at the 
> > > drives via Windows Explorer I see the following
> > >
> > > Computer
> > >                    OS(C:)
> > >                    Data(F:)
> > >                    Logs(H:)
> > >                    Work(I:)
> > >                    Backup(K:)
> > >                    ...
> > >                    ...
> > >
> > > I figure that I need a folder in one of these drives to be the 
> > > target of
> > the MOUNT.
> > > So what do I specify for MFS and MNTOVRDIR?
> > >
> > > Peter
> > >
> > > ####################################################################
> > > ##
> > > ###############
> > >
> > > This correspondence is for the named person's use only. It may 
> > > contain confidential or legally privileged information, or both. No 
> > > confidentiality or privilege is waived or lost by any mistransmission.
> > > If you receive this correspondence in error, please immediately 
> > > delete it from your system and notify the sender. You must not 
> > > disclose, copy or
> > rely on any part of this correspondence if you are not the intended 
> > recipient.
> > > Any views expressed in this message are those of the individual 
> > > sender, except where the sender expressly, and with authority, 
> > > states them
> > to be the views of Veda.
> > > If you need assistance, please contact Veda on either :- Australia
> > > 1300-762-207 or New Zealand +64 9 367 6200
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) 
> > mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To 
> > subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take 
> > a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.