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
F/ASSERT-MSGMCH3203-MOD/QQQOOODBOP QUERY WITH AGGREGATE FAILS
DURING OPTIMIZATION WITH A FUNCTION CHECK
Error Description
A query with aggregate is failing during optimization with a
function check. VLOG shows the following failing offset:
MODULE DBOPNODE + 0001EA5C
ENTRY
EXITWITHCHANGEVALUEERROR__FR6MACOUTP13DBOPEXPRVALUET2PCCRC11DBOP
STRINGXXSP16_ + 0000021C
Problem Summary
****************************************************************
* PROBLEM: (MA44711) Licensed Program = 5770999 for i 7.1 and *
* i 7.2 *
* Usability of a Product's MAJOR Function *
* Many Left Outer Join queries fail. *
****************************************************************
* USERS AFFECTED: All IBM i operating system users. *
****************************************************************
* RECOMMENDATION: Apply LIC PTF MF60346 for i 7.1. *
* Apply LIC PTF MF60354 for i 7.2. *
****************************************************************
*******
A query containing a left outer join is failing during
optimization with a function check and MSGMCH3203. The
corresponding 0600 BADD LIC log refers to MODULE DBOPNODE and
ENTRY EXITWITHCHANGEVALUEERROR. The failure is occurring due to
an incorrectly built query tree.
Problem Conclusion
This fix corrects how the query tree is constructed so that the
query runs successfully.
Temporary Fix
*********
* HIPER *
*********
Comments
Circumvention
PTFs Available
R710 MF60346 
5317
R720 MF60354 
5310
Affected Modules
Affected Publications
Summary Information
| Status............................................ | CLOSED PER |
| HIPER........................................... | Yes |
| Component.................................. | 9400DG3DBMF6 |
| Failing Module.......................... | RCHMGR |
| Reported Release................... | R710 |
| Duplicate Of.............................. |
System 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 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:
08 September 2017