• Subject: Re: slow queries over tcp/ip
  • From: rob@xxxxxxxxx
  • Date: Mon, 6 Nov 2000 13:30:55 -0500


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



+---
| 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 thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2019 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].