Re: slow queries over tcp/ip -- MIDRANGE-L

I use Client Access via TCPIP connections at several client sites. At all of them, response is comparable to twinax connection - whether it be SQL, QRY, or interactive display. The only time that I have slow response times is when I use an AnyNet connection.
========================================

Yes. I do believe that this would be the case. Are you getting at something? Why would this matter? Again, ALL 5250 terminals are OK under ALL circumstances. ALL PC's communicating over tcp/ip are affected by this slowdown.
If there is anyone out there using tcp/ip? Do you generally see improved speeds vs twinax?
Thanks, Keith
----- Original Message ----- From: <rob@dekko.com> To: <MIDRANGE-L@midrange.com> Sent: Monday, November 06, 2000 4:32 PM Subject: Re: slow queries over tcp/ip

> > Let me rephrase my question, Are both the terminal sessions and the > pc-5250 sessions running in the QINTER subsystem? Again, rephrased, (in > case you don't know how to check), if I do a WRKACTJOB will both the > terminal, and the pc-5250, sessions appear indented under QINTER? > > Rob Berendt > > ================== > Remember the Cole! > > > > "Keith Schwarz" > <KeithS@flowlinefit To: <MIDRANGE-L@midrange.com> > tings.com> cc: > Sent by: Subject: Re: slow queries over tcp/ip > owner-midrange-l@mi > drange.com > > > 11/06/00 02:48 PM > Please respond to > MIDRANGE-L > > > > > > > The simple answer is yes. Regarding the pc's running tcp/ip over twinax, I > have a pc sitting right next to a terminal running over the same line. The > exact same query on the 5250 terminal runs fine. The query on the pc using > tcp/ip runs 5 to 10 seconds slow. As far as the pc's running through the > hub, I don't know if they are in the same subsystem. I am not familiar > with > that terminology as it relates to this case. They are not on the same > physical line but the are running the same type of queries, except the are > communicating over cat 5 thru a hub connected to the ethernet card in the > 400. > > Hope that answers your question. > > Thanks, > Keith > ----- Original Message ----- > From: <rob@dekko.com> > To: <MIDRANGE-L@midrange.com> > Sent: Monday, November 06, 2000 1:30 PM > Subject: Re: slow queries over tcp/ip > > > > > > Are both the terminals and the pc-5250 sessions in the same subsystem? > > > > Rob Berendt > > > > ================== > > Remember the Cole! > > > > > > > > "Keith Schwarz" > > <KeithS@flowlinefit To: > <MIDRANGE-L@midrange.com> > > tings.com> cc: > > Sent by: Subject: Re: slow > queries over tcp/ip > > owner-midrange-l@mi > > drange.com > > > > > > 11/06/00 12:32 PM > > Please respond to > > MIDRANGE-L > > > > > > > > > > > > > > More info: > > > > Client acesss is running tcp and it is slower. 5250 sessions run > > normally with no slowdown. What I mean by slow is that a query running > > over > > a 5250 terminal will appear almost instantly were a query over client > > access > > will take several seconds (5 - 10 seconds). Enough of a time gap that > > someone that works with these regularly would have a problem with it. > Let > > me state that I don't know that this is just queries. This is just were > it > > is most apparent. > > > > The reason that I don't believe that it is the hub is that we do have > a > > few machines that are running tcp/ip over twinax. They are not going > > through the hub. The twinax line has both 5250 terminals and the PC's. > > The > > terminals run the queries fine but the pc's have the same noticable > > slowdown. The other reason that I believe it is not the hub is that we > > have > > not gone live with tcp/ip company wide and there are only 3 pc's activive > > through this hub at this time. > > > > Thanks, > > Keith > > ----- Original Message ----- > > From: <rob@dekko.com> > > To: <MIDRANGE-L@midrange.com> > > Sent: Monday, November 06, 2000 10:04 AM > > Subject: Re: slow queries over tcp/ip > > > > > > > > > > 1) How are you doing the queries over tcp? Basically I am trying to > > find > > > out if TCP is germane to your problem. For example if you just changed > > > your Client Access from SNA to TCP and your 5250 sessions run query > > slower > > > than I would say that the TCP is not even close to being the problem. > > > Perhaps you've had data growth or a PTF affecting database applied > which > > > may be the culprit. > > > > > > More data please... > > > > > > > > > Rob Berendt > > > > > > ================== > > > Remember the Cole! > > > > > > > > > > > > "Keith Schwarz" > > > <KeithS@flowlinefit To: > > <MIDRANGE-L@midrange.com> > > > tings.com> cc: > > > Sent by: Subject: slow > queries > > over tcp/ip > > > owner-midrange-l@mi > > > drange.com > > > > > > > > > 11/06/00 08:36 AM > > > Please respond to > > > MIDRANGE-L > > > > > > > > > > > > > > > > > > > > > We are slowly moving to tcp/ip communication on our 400. Generally, > > things > > > have been OK. The only drawback that I have seen so far is that > querees > > > done on the database over tcp/ip are very slow compared to previous. > > Does > > > anybody have any ideas why this may be? I don't believe it is the hub. > > > Are > > > there any settings on the 400 that might explain? > > > > > > Thanks, > > > > > > Keith > > > _______________________________________ > > > Keith E. Schwarz > > > Accounting Manager > > > Flowline Division of Markovitz Enterprises Inc. > > > KeithS@flowlinefittings.com > > > 724-658-3711 ext 1032 Phone > > > 724-658-5323 Fax > > > _______________________________________ > > > > > >