Database problem in 4.2 - Help

["Reger, Bill" <breger@xxxxxxxxxx>]

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.
If we press F10 to update stack, sometimes it shows the QDBGETKY, other
times the job stack is totally blank. This is executing on 23 other AS400s,
all at V4R2, with cum 180 recently applied. IBM has recommended SF99102 - a
whole bunch of database ptfs, with no particular ptf in mind. We are afraid
to wait. This is hurting us. Any help would be appreciated.

William K. Reger
Senior Project Manager
Levitz Furniture Corporation
Phone:  (561) 994-5114
E-mail:  breger@levitz.com <mailto:breger@levitz.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
+---