RE: Database problem in 4.2 - Help

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

Thanks Al.  For your information, we loaded SF99102 and it did fix the
problem.  It cost us a few days of hassles until we got it loaded though,
but everything seems okay now.  Thanks for the help!

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


-----Original Message-----
From:   Al Barsa, Jr. [mailto:barsa2@ibm.net]
Sent:   Monday, September 27, 1999 1:23 PM
To:     MIDRANGE-L@midrange.com
Subject:        Re: Database problem in 4.2 - Help

At 01:55 PM 09/24/1999 -0400, you 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.
>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.
SF99102 sounds like the database group PTF for 4.2.  Without this group PTF 
on, I would suggest that you have no chance of any other help.

Al




+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:          914-251-1234
Fax:            914-251-9406
http://www.barsaconsulting.com
http://www.taatool.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
+---
+---
| 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
+---