RE: NFS Mount -- MIDRANGE-L

Actually, in my case it's more secure since the PC is in fact the Windows box running SQL Server but which also has IBM Client Access installed just like on a PC.
I have the IBM Client Access remote command service active on the Windows box just so I can have it wait for a RUNRMTCMD request from the i5.
I already have a vbs script on the Windows box that will suck a csv file from the i5 using FTP so I when I issue the RUNRMTCMD the csv file ends up on the Windows box.

Peter

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Roger Harman
Sent: Sunday, 2 June 2013 5:28 p.m.
To: 'Midrange Systems Technical Discussion'
Subject: RE: NFS Mount

Because FTP or a PC with a drive mapped to the i and to the MS server and copying back & forth is so much more secure, huh?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Connell
Sent: Saturday, June 01, 2013 9:36 PM
To: Midrange Systems Technical Discussion
Subject: RE: NFS Mount

Thanks guys.
Interesting comment from Roger re head banging the admin guys. I have an FTP workaround for the same reason.

Peter

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Sunday, 2 June 2013 4:29 p.m.
To: Midrange Systems Technical Discussion
Subject: Re: NFS Mount

You don't need to start the NFS server on the i - only on the remote system, whether Windows or Linux or whatever.

That redbook is pretty sketchy, as I recall, as to using the NFS client on IBM i. Of course, there's not much to that, since all you do is run the MOUNT command.

Security is different - I point Peter again to the RJS articles to help with anonymous mounts. There are some newer articles, as I recall, on support.rjssoftware.com - and older yet still valid articles on wiki.rjssoftware.com/wiki - not all of those had made it over to the newer support site as of my last days working there, so take a look both places.

HTH
Vern

On 6/1/2013 10:57 PM, Roger Harman wrote:

You're mixing them up. Unix Services is on the Windows side. On the
i, look at STRNFSSVR.

There is a redbook on NFS. Pretty old but should point you in the
right direction.
http://www.redbooks.ibm.com/abstracts/sg242158.html

One reason I never got it running was resistance from the Windows
admin guys. I ended up with a combination of FTP and a PC as the

middleman to

accomplish what I needed. Would have been a lot cleaner to go NFS.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Connell
Sent: Saturday, June 01, 2013 8:45 PM
To: Midrange Systems Technical Discussion
Subject: RE: NFS Mount

Richard,
Thanks for the tip but how do I enable Windows Services for Unix NFS
server support on the i5?
Peter

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Richard Schoen
Sent: Sunday, 2 June 2013 3:39 p.m.
To: midrange-l@xxxxxxxxxxxx
Subject: RE: NFS Mount

If you want i to mount a Windows drive share, enabled Windows Services
for Unix NFS server support.

Otherwise you could enabled the NFS server on i and mount the IFS
shares from Windows.

I would recommend the first option.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------

message: 2
date: Sun, 2 Jun 2013 10:56:01 +1000
from: Peter Connell <Peter.Connell@xxxxxxxxxx>
subject: NFS mount

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 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.

############################################################################
#########

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.

#####################################################################################

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