RE: Query Question...

[Vernon Hamberg <vhamberg@xxxxxxxxx>]

If everybody is using read-only, there's less chance of locks, and they'd
be short.

If a user is updating a record, others may need to wait, even to read it.
Depends on the apps.

At 02:44 PM 6/5/02 +0100, you wrote:
>Why does a query have want exclusive access? Shouldn't it be shared or do
>you mean that other users' have exclusive access so the query can't read the
>records?
>
>Thanks,
>
>Jenny
>
>-----Original Message-----
>From: Vernon Hamberg [mailto:vhamberg@attbi.com]
>Sent: 05 June 2002 13:39
>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.
>_______________________________________________
>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.