Re: Data transfer speeds

Dave,


> My client has an SQL server that they are grabbing information from their
iSeries and downloading.  Using a Select > statement, selecting all the
fields from a very large file, a job starts on the iSeries called QRWTSRVR.
> The transfer speed of the data slowly rises up until it reaches 10M, it
then stays at 10M until the job is
> complete. (They have a 100M Ethernet card installed on all servers.) They
have some type of sniffer device
> attached to their network showing them the exact transfer speed.
> Is there a secret to opening that pipe so the transfer happens quicker?

Sorry for the late answer, have you tried to go into CFGTCP option 3 and
change the buffer sizes to a larger value? Default values are 8192 try
change them to 65025 and see if there's any difference.

If you are using ftp on a large file - will the transfer speed be the same?

Network congestion?

Best Regards

Stefan Tageson
Intentia Consulting Sverige AB
Propellergatan 1, SE-211 19 Malmö, Sweden
Phone: +46 (0)40 691 35 00
Cell: +46 (0)733 913 813
Fax: +46 (0)40 691 3900
E-mail: stefan.tageson@intentia.se