Subscribe to this APAR
By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.
APAR (Authorized Program Analysis Report) |
Abstract
OSP-DB-OTHER-PERFM PERFORMANCE IMPROVEMENT TO QDS IO COSTING
Error Description
Performance improvement to QDS IO Costing
Problem Summary
Please see the ERROR DESCRIPTION section.
Problem Conclusion
The IO costing model for temporary objects (QDSs) used the
SQE optimizer is changed to start the IO costing curves sooner.
This change in IO cost behavior is enabled by setting the
QAQQINI option SERVICE_AQ to *YES. When this INI option is
enabled, the SQE optimizer will start costing IOs for the
temporary objects at the smaller of 300M or at the query fair
share. This will in general bias the optimizer towards index
plans.
Temporary Fix
Comments
Circumvention
PTFs Available
R720 MF65924 9297
R730 MF65717 9311
Affected Modules
Affected Publications
Summary Information
Status............................................ | CLOSED PER |
HIPER........................................... | No |
Component.................................. | 9400DG3DB |
Failing Module.......................... | RCHMGR |
Reported Release................... | R730 |
Duplicate Of.............................. |
IBM i Support
IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information
Document Information
Modified date:
15 November 2019