IBM Support

MA47143 - LIC-DB-MSGMCH3203 AFFINITY ERROR ON COMPLEX QUERY

 APAR (Authorized Program Analysis Report)

Abstract

LIC-DB-MSGMCH3203 AFFINITY ERROR ON COMPLEX QUERY

Error Description

Complex query resulted in MSGMCH3203.                          
DbopAffinity::getCachedDbstMdExpr                              
    COUNTREGISTER   FFFFFFFFCF 0E01F0     MODULE@   FFFFFFFFCF  
0E01F0     ENTR                                                
     MODULE   assert + 00000000                                
     ENTRY    aserrt + 00000000                                
ISF ADDRESS   FD76675AC3 FF8C80       TYPE SLIC                
    RESUMEPOINT     FFFFFFFFCB 708A50     MODULE@   FFFFFFFFCB  
705CE0     ENTR                                                
     MODULE   DbopAffinity + 00002D70                          
     ENTRY                                                      
getCachedDbstMdExpr__Q2_12DbopAffinity24AffinityExpressionSource
     LIC LOG ENTRY ID 0100E47F SQE                              
OPTIMIZER EXCEPTION                                            

Problem Summary

Please see the ERROR DESCRIPTION section.                      

Problem Conclusion

A modification made to the query tree late in optimization was  
not correct, resulting in MCH3203. The modfication will now be  
recognized and the appropriate cached information will be      
rebuilt.                                                        

Temporary Fix

Comments

Circumvention


PTFs Available

R720 MF65090 PTF Cover Letter   8249
R730 MF65089 PTF Cover Letter   8242

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... Yes
Component.................................. 9400DG3DB
Failing Module.......................... RCHMGR
Reported Release................... R720
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, 2018 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

More support for: i family

Software version: V7R2M0, V7R3M0

Operating system(s): OS/400

Reference #: MA47143

Modified date: 14 September 2018