Re: query problems / reading files

["Maarten Vries, de" <m_devries74@xxxxxxxxxxx>]

Rob

We ran our own application. But they are just a bunch of files, not that 
big.
It is a query using joins.
What is confusing that only the model 730 is failling, all the other systems 
are running fine and receiving blocks of 10000 at a time. It looks like it 
cannot read all the blocks at one.
So I issued a OVRDBF where you can specify something for blockreading 
SEQONLY but that did not help.
IBM cannot figure out the problem to.

Maarten


>From: rob@dekko.com
>Reply-To: MIDRANGE-L@midrange.com
>To: MIDRANGE-L@midrange.com
>Subject: Re: query problems / reading files
>Date: Mon, 14 May 2001 10:26:32 -0500
>
>
>I assume that the 820 and the other machines are all running V4R5, the same
>CUM, and, if you run:
>DSPDTAARA DTAARA(SF99105)
>there is no disparity, correct?
>
>What application are you querying against?  Basically, if it is BPCS or one
>of our other applications I could try it for you.
>
>Rob Berendt
>
>==================
>Remember the Cole!
>
>
>
>                     "Maarten Vries, de"
>                     <m_devries74@hotmai        To:     
>MIDRANGE-L@midrange.com
>                     l.com>                     cc:
>                     Sent by:                   Subject:     query problems 
>/ reading files
>                     owner-midrange-l@mi
>                     drange.com
>
>
>                     05/14/01 09:19 AM
>                     Please respond to
>                     MIDRANGE-L
>
>
>
>
>
>
>We are running lots and lots of queries on our systems.
>Recently we have upgrade to V4R5M0 and now we experience very very long
>runtimes of the queries.
>
>You can see that when the query runs, it is reading 300 records at the time
>on a model 730 with 2GB main storage.
>When I run the query on another system it is reading by blocks of 15000.
>The other system is a base model 620.
>
>This problem is happening on lots of systems, but I tested the query on a
>model 820 and did not have any problems.
>
>Another branch of us also runs on a model 620 and there the problem is
>occuring. PTF level is the same and IBM cannot find the solution.
>Does this ring a bell to anyone?
>
>Maarten
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
>+---

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
+---