Re: Database problem in 4.2 - Help

[HwaRangRon@xxxxxxx]

Bill,

We encountered something similiar a long time ago. It turned out that an index 
was being built over a large file everytime we accessed it (because of the open 
qerry file.) If you do a DSPFD over the database file, it should show the 
number of access paths that the system has had to build over the file. Also, we 
could not access the file while the index was being built.

IMB sent us a lot of PTF's, but the as I remember the final resolution was to 
rewrite the program so that it didn't use the OPNQRYF. 

HTH
Ron
Bill wrote: 
Help - we have an RPG/400 pgm reading an OPNQRY file (a join
 of 2 fairly
 large files, accessed by an index). The pgm opens and in the
 job stack we
 see QDBGETKY executing. The pgm is obviously hung, and eats
 up all the CPU.
+---
| 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
+---