RE: New query attributes file - QAQQINI

["Marion, Bob" <Bob.Marion@xxxxxx>]

I upgraded to V4R4 over a month ago and had to switch to the QAQQINI file
from the QQQOPTIONS data area.   There was not a formula to effectively set
the INI file, so it was trial and error.  Step 1 is to copy the INI file
from QSYS to QUSRSYS for global use of the file.  I edited the file in
QUSRSYS and changed the OPTIMIZE_STATISTIC_LIMITATION record to fit my
environment using the Percent option, which basically tells the query
optimizer what percent of the file to read before making a decision on the
logical to utilize.  The day after my upgrade an SQL job went from running
in 30 seconds to taking a hour to complete, this is when I started adjusting
the INI file.  The book with a little info is the SQL programming manual
starting on page 543.  I suggest calling IBM support and requesting the
Query optimizer team explain how the optimizer now works, it is to detailed
for this posting.     



Bob Marion
Phone:  972/461-3186
email:  bob.marion@ps.net


-----Original Message-----
From: James_Turnbull@kaz.com.au [mailto:James_Turnbull@kaz.com.au]
Sent: Wednesday, October 13, 1999 11:23 PM
To: MIDRANGE-L@midrange.com
Subject: New query attributes file - QAQQINI


Peoples

Has anyone used the replacement for the QQQOPTIONS data area in V4R4?  The
new
file QAQQINI is not exactly well documented, another bloody Info Center
manual.
Does anyone know what settings to use to duplicate the data area's purpose?
Ie.
What would you put in the file to replicate the data area if the data area
was
'C0080'?  It would be easier if the new file doco told you how to migrate
instead of just telling you they have superseded the data area.

Thanks in advance

James Turnbull


+---
| 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
+---