RE: Data transfer speeds

["Smith, Dave" <DSmith@xxxxxxxxx>]

I posted this a couple weeks back.  We were having very slow transfer speeds 
down to an SQL server with an OLE/DB connection. We switched to the "old" 
method: ODBC and it flies.  What was 1.5 hours to download some large files is 
down to 10 minutes.   Don't get it, but I'm happy now.

David Smith
Tri-State Hospital Supply Corp.
IT Consultant
dsmith@tshsc.com
517.546.5400


-----Original Message-----
From: Smith, Dave
Sent: Tuesday, October 08, 2002 1:27 PM
To: 'midrange-l@midrange.com'
Subject: Data transfer speeds


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?

If there is a cut off at 10M, is that a job restriction.  Could they run 
consecutive jobs (Selects) over the same file specifying different Where 
clauses so each job is downloading at 10M?

Below is the first screen on their line description.

     Display Line Description                   S44AB541
                                                             10/08/02  11:03:56
 Line description . . . . . . . . . :   LINE1ETH
 Option . . . . . . . . . . . . . . :   *BASIC
 Category of line . . . . . . . . . :   *ELAN

 Resource name  . . . . . . . . . . :   CMN10
 Online at IPL  . . . . . . . . . . :   *YES
 Vary on wait . . . . . . . . . . . :   *NOWAIT
 Network controller . . . . . . . . :   LINE1NET
 Local adapter address  . . . . . . :   420000000001
 Exchange identifier  . . . . . . . :   056AB541
 Ethernet standard  . . . . . . . . :   *ALL
 Line speed . . . . . . . . . . . . :   100M
 Current line speed . . . . . . . . :   100M
 Duplex . . . . . . . . . . . . . . :   *FULL
 Current duplex . . . . . . . . . . :   *FULL
 Maximum frame size . . . . . . . . :   1496
 Maximum controllers  . . . . . . . :   40

They are using an OLE/DB connection.

Thanks for your help!