• Subject: Re: slow queries over tcp/ip
  • From: rob@xxxxxxxxx
  • Date: Mon, 6 Nov 2000 16:32:19 -0500


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

As an Amazon Associate we earn from qualifying purchases.

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