Re: IFS and FTPing libraries

I always use save files, too, but I'm usually backing up QSYS libraries. Nick said something about QDLS. If he's trying to ftp Windows or Linux folders/directories, would this be a moot point? I.e., those are stream files, anyway, with no direct knowledge of fields and attributes. So wouldn't they ftp across OK without being put into a save file first? On the other hand, he did say SAVLIB, not SAV.

The 2.5 hours seemed like a long time for a save and ftp; I regularly save and ftp a 1+ gb library in about 10 minutes. But then I noticed that he is on a 620. I'm not familiar with the model, except that it's an old one. That could explain some of the time; i.e., the save is only going to go so fast. But as regards the ftp speed, isn't there a network setting that he might look at? Or is the 620 constrained in this regard as well?

* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



rob@xxxxxxxxx wrote:

You did say libraries, not directories.
By IFS did you mean ftping from
/QSYS.LIB/AMFLIB.LIB/*
I really don't think that will maintain the attributes. For example

CREATE TABLE ROB/NICKY

(MYCHAR CHAR (15 ), MYDEC DEC (7 , 2), MYZONE NUMERIC (7 , 2)) Table NICKY created in ROB.

INSERT INTO ROB/NICKY VALUES('A', 1.2, 2.3)

1 rows inserted in NICKY in ROB.

INSERT INTO ROB/NICKY VALUES('B', 3.4, 4.5)

1 rows inserted in NICKY in ROB.
>From my PC:
C:\Documents and Settings\ROB>ftp gdisys
Connected to gdisys.dekko-1.
220-QTCP at GDISYS.dekko-1.
220 Connection will close if idle more than 5 minutes.
User (gdisys.dekko-1:(none)): rob
331 Enter password.
Password:
230 ROB logged on.
ftp> cd /qsys.lib/rob.lib
250-NAMEFMT set to 1.
250 "/QSYS.LIB/ROB.LIB" is current library.
ftp> bin
200 Representation type is binary IMAGE.
ftp> get nicky.file
200 PORT subcommand request successful.
150 Retrieving member NICKY in file NICKY in library ROB.
226 File transfer completed successfully.
ftp: 52 bytes received in 0.08Seconds 0.67Kbytes/sec.

Back on the i5

drop table rob/nicky

Back in the same ftp session on my pc
ftp> put nicky.file
200 PORT subcommand request successful.
150 Sending file to member NICKY in file NICKY in library ROB.
226 File transfer completed successfully.
ftp: 52 bytes sent in 0.00Seconds 52000.00Kbytes/sec.

Back on the i5

select * from rob/nicky

....+....1....+....2....+....3....+....4....+....5..
NICKY A * 0000230B * 0000450
******** End of data ******** Cannot show this data at the display station.

Notice, one big field?
Also notice, two records are now in one record? "A" and "B"?

Summary: Do not bypass saving it to save file or virtual tape.

Rob Berendt