Query Question...

["Chuck Lewis" <clewis@xxxxxxxxxx>]

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