• Subject: Re: slow queries over tcp/ip
  • From: tomh@xxxxxxxxx
  • Date: Tue, 7 Nov 2000 16:42:01 -0600


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
> > > _______________________________________
> > >
> > >


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.