× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



That's what I was thinking and you and Carel have helped confirm it. This
Query user is our CFO and he very good and understands the value of finding
Logicals with decent keys, etc. so we normally don't see this problem. Of
course he is very smart and pushes Query to the limits :-) He keeps
mentioning that he wants to learn to program but we don't have the time
(small/me shop). So he usually just has me turn them into programs when they
get to involved !

Thanks again,

Chuck

-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On Behalf Of Vernon Hamberg
Sent: Wednesday, June 05, 2002 7:39 AM
To: midrange-l@midrange.com
Subject: RE: Query Question...


Hash tables are built for, among other things, joins when there are not
suitable indexes. Don't remember, but there may be hash tables used for
selection, too.

I'd guess there are lock problems when users come on the system.

At 09:49 AM 6/4/02 -0500, you wrote:
>OK,
>
>This was running in QBATCH...
>
>I just fired it up interactively and see the info message:
>
>Building hash table from file POLTOL1 in HD1100PD.
>
>So it is having to do something extra I assume ? What does this mean in
>query ?
>
>Thanks,
>
>Chuck
>
>-----Original Message-----
>From: midrange-l-admin@midrange.com
>[mailto:midrange-l-admin@midrange.com]On Behalf Of Chuck Lewis
>Sent: Tuesday, June 04, 2002 9:45 AM
>To: Midrange-L
>Subject: Query Question...
>
>
>Hi Folks,
>
>We have a query (via IBM's Query) that runs FINE when no one is on the
>system (2 - 3 minutes) but horrible when users are on (2+ HOURS !)...
>
>It is going against some files in a third package we have (Mincron's HDS
>package) and involves 3 files. Primary is NOT keyed, the other 2 are.
>
>I fired it up as a test and when it starts running and I do Display Open
>Files I see:
>
>                              Display Open Files
>Job . . :   QDFTJOBD       User . . :   CHUCK          Number . . . :
>342472
>Number of open data paths . . . . . . . . . . :      2
>
>                           Member/    Record     File   I/O   ----Open---
> Relative
>File       Library    Device     Format     Type  Count  Opt Shr-Nbr
Record
>*QUERY0001
>QTEMP      *QUERY0001                                          PHY       0
>  O   NO
>POLTOL1    HD1100PD   POLTOL1               LGL       0  I   NO
>
>
>Is that *QUERY0001 an access path being built ?
>
>Been a LONG time since I messed with this stuff and a vague recollection
>says yes...
>
>Thanks !
>
>Chuck
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.