Re: Problems with Query on V4R5

[MWalter@xxxxxxxxxxxxxxx]

Be sure you have the latest DB PTF's applied. We too had some queries that
run every day. All of the sudden, a query bombs with some kind of strange
pointer error. The object description of the QRYDFN says that the object
hasn't been changed since we restored it from our upgrade a year ago. The
files are open order header and detail files so I know they didn't change.
The real funny thing is that the next day, without any changes, the query
ran fine.  I called tech support and they told me about the latest DB
PTF's. I thought I had them on but IBM must be changing them like
underwear. It's a full time job keeping up with the fixes and patches
between OS/400, DB2, Domino, and WDT400. I really feel for shops that have
more than one system.

Ok, rant over for today.




Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040


                                                                                
                                         
                    "Murphy, Guy"                                               
                                         
                    <murphy@uif.uillino        To:     
"'MIDRANGE-L@midrange.com'" <MIDRANGE-L@midrange.com>             
                    is.edu>                    cc:                              
                                         
                    Sent by:                   Subject:     Problems with Query 
on V4R5                                  
                    owner-midrange-l@mi                                         
                                         
                    drange.com                                                  
                                         
                                                                                
                                         
                                                                                
                                         
                    06/14/01 11:29 AM                                           
                                         
                    Please respond to                                           
                                         
                    MIDRANGE-L                                                  
                                         
                                                                                
                                         
                                                                                
                                         




        Has anyone had some of their queries not work the same since
upgrading to V4R5? We've have a set of queries that use three files and
print out text fields on the report in FIFO order in effect writing a
paragraph of information on the report.  These text fields are not used as
key fields in the report and are not used as sort fields in the query.
After upgrading to V4R5 these fields are now being printed on the reports
in alphabetical order, which makes them rather useless as a paragraph of
information.


        IBM says that the query optimizer has been improved for performance
in V4R5 and that it's working as designed.  Therefore, it's not a problem
and they will not work on solving it.  To me, the optimizer has gone
psychotic and is doing more work that is required.  It's takes a non-key,
non-sort field and makes a sort field.  IBM recommends either rewriting the
queries in SQL using record sequence order or adding a new field to the
files and using it as a sort field to get the text fields to print
properly.  Some of these queries have been around since V2R3. Is there any
solution to this problem that doesn't require us to rewrite all of these
queries or do we have to bite the bullet and rewrite?


Guy Murphy - murphyfa@uiuc.edu
FACTS system - University of Illinois
217-333-8670
www.heisercoaching.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
+---