Re: slow queries over tcp/ip

["Keith Schwarz" <KeithS@xxxxxxxxxxxxxxxxxxxx>]

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
> _______________________________________
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---