Depending on the size we'll use FTP or WRKLNK QFileSvr.400.
QFileSvr.400 works for database files-- but you have to use the 'funny' references: >QSYS.LIB/MYLIB.LIB/MYFILE.FIL/MYMBR.MBR< and so on.
Here's what we've added to our "How To Do It" document (liberally sponged from here):
Mark Lazarus wrote: Is it possible map a remote directory (on a Unix or Windows server machine or even on another AS/400 - on the local network) via a *SYMLNK in the IFS? I would like to be able to set up the link once and be able to use the CPY command. The alternative is FTP, but I think that a single command, without building a script is more elegant. TIA.
From: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
Three ways. /QFileSvr.400, /QNTC, and NFS.
The iSeries supports all 3 (obviously) so for iSeries to iSeries communication, you can use any/all of the above.
UNIX supports both NFS and /QNTC (the latter is supported using a program called SAMBA)
And of course, jolly ol' Windows works with /QNTC.
Each system tends to work best with its native system... i.e. the iSeries with QFileSvr.400, UNIX with NFS, and well... Windows never really works well. :)
From: Larry Bolhuis <lbolhuis@xxxxxxxxxx>
OS/400) Either a TCP/IP or SNA connection needs to exist. Then create a directory with the other system's name in /qFileSvr.400 User ID and Password must match. You can see the entire IFS of the target machine. Super cool.
*NIX) You need to configure NFS between the machines. Basically you export the directory on the *NIX box and then Mount it on the AS/400 side. In this case you mount the remote directory over top of a (hopefully empty) directory in the IFS. UID is used rather than userid and password so you'll need to map the UID numbers between OS/400 profiles and *NIX profiles. You'll also need the NFS Servers running (STRTCPSVR *NFS)
Windoze) You can either use NFS (as above) if the proper bits are installed on Windows or you can use the /QNTC directory. This requires configuring the Netserver to be in the domain or workgroup of the target servers. User ID and password must match. Create a directory in the
/QNTC directory that matches the server's name (if it doesn't exist). Under that directory you should see the shares for that server.
I realize this isn't a lot of detail but it took me 3000 words to describe it all when I wrote about it!! Hope it helps! - Larry
Q: Does anybody know how to copy or move Image-Catalogues from one system
to another (same releases) ? V5R3 and higher ...
A: Create the image catalogue on the remote system and FTP over the files
in the IFS then use ADDIMGCLGE:
ADDIMGCLGE IMGCLG(PTFCATALOG)
FROMFILE('/iPTF/FileName.bin')
TOFILE(*fromfile)
Make sure the TOFILE parm is *fromfile so it does not duplicate the file.
A: My solution involved no ftp.
My solution used the special IFS directory called QFileSvr.400. Just to
see how cool QFileSvr.400 is try the following:
Let's say you are on system X locally. And you want to see system Y. Then
try the following on system X:
MD '/QFileSvr.400/Y'
WRKLNK '/QFileSvr.400/Y'
All sorts of directories on your remote system should show up.
Use the CPY command to move a directory's worth of PTFs to the 'other' machine:
CPY OBJ('/PTFs/V7R3.170505/*') TODIR('QFileSvr.400/PLANO01/PTFs/V7R3.170505') SUBTREE(*ALL)
From Directory To Directory
Comment:
Since typing QFileSvr.400 can be a little awkward, especially if you have to do
it repeatedly, after doing Rob's stuff create a symbolic link to the other machine:
ADDLNK OBJ('/QFileSvr.400/Y') NEWLNK('/Y')
Now, just do WRKLNK '/Y'
Thanks to Chris Bipes, Rob Berendt and John Jones
--This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
CPFA09C message--Not authorized to Object. Object is /QFileSvr.400/remotesystem
CPFA09C cause--You do not have the correct authority for object
/QFileSvr.400/remotesystem or for one of the directories in the object path
This is an authority message related to the user profile you are signed on with on the local system. For QFileSvr.400 object links to work, the user profile on the local system must have the same user profile name and password as an authorized user on the remote system. If the profile name and password don't match, the connection will be rejected.
If the profile is disabled on either system, the connection will be rejected!
Paul E Musselman
PaulMmn@xxxxxxxxxxxxx
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Mihael Schmidt
Sent: Tuesday, November 06, 2018 7:46 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Data Transfer
Hi everybody,
this topic seems old and I have seen many threads about it over a decade
ago but I want to know how are you transferring data (database tables)
from one IBM i server to another IBM i server today.
My scenario is not HA so I don't need a duplicating setup with
journaling. I want to transfer the data at a regular interval and
optionally do some processing on the remote machine.
Data volume varies though we are not in the GB area.
Compressing the data before sending would also be nice in this setup to
save bandwidth.
Thanks for any suggestion.
Mihael
midrange.com
