SE66895 - F/ASSERT-MSGMCH3203-RC1720-MOD/ASSERT SP UPDATE SQL SENTENCE
FAILS WITH MCH3203 AFTER CUM6320 AND SF99701-41 WAS APPLIED

APAR (Authorized Program Analysis Report)

Abstract

F/ASSERT-MSGMCH3203-RC1720-MOD/ASSERT SP UPDATE SQL SENTENCE
FAILS WITH MCH3203 AFTER CUM6320 AND SF99701-41 WAS APPLIED

Error Description

MCH3203 Escape 60 03/06/17 07:02:12.731680 assert 000004        
QQQOOODBOP QSYS *STMT                                          
To module . . . . . . . . . : QQQOOOINV                        
To procedure . . . . . . . : CALLDBMAINTFOROPENOROPTIMIZE      
Statement . . . . . . . . . : 4720                              
Thread . . . . : 0000142F                                      
Message . . . . : Function error X'1720' in machine instruction.
Internal dump identifier (ID)                                  
                                                               
VLOGS                                                          
0600 BADD DATABASE                                              
0200 1720 FUNCTION CHECK                                        
0600 BADD DATABASE                                              
                                                               
query(UPDATE MAS_STYLE_LIST_MAP_XREF SET MMSX_BATCH_PROC_STAT =
'PROCESSING' WHERE MMSX_MAP_DEF_ID IN ( SELECT MPDF_MAP_DEF_ID  
FRO                                                            
M MAS_STYLE_LIST_MAP_DEF INNER JOIN MAS_MERCH_DIVISION ON      
MMDV_MERCH_DIV_ID = MPDF_MERCH_DIVISION_ID AND                  
MMDV_BRAND_GRP_ID = : H :                                      
H AND MPDF_MERCH_SEASON_ID = : H : H AND MPDF_THEME_GRP = : H :
H ) AND MMSX_BATCH_PROC_STAT = 'UPDATED' AND MMSX_STATUS =      
'INACT                                                          
IVE' )                                                          

Problem Summary

MCH3203 Escape 60 03/06/17 07:02:12.731680 assert 000004        
QQQOOODBOP QSYS *STMT                                          
To module . . . . . . . . . : QQQOOOINV                        
To procedure . . . . . . . : CALLDBMAINTFOROPENOROPTIMIZE      
Statement . . . . . . . . . : 4720                              
Thread . . . . : 0000142F                                      
Message . . . . : Function error X'1720' in machine instruction.
Internal dump identifier (ID)                                  
                                                               
VLOGS                                                          
0600 BADD DATABASE                                              
0200 1720 FUNCTION CHECK                                        
0600 BADD DATABASE                                              
                                                               
query(UPDATE MAS_STYLE_LIST_MAP_XREF SET MMSX_BATCH_PROC_STAT =
'PROCESSING' WHERE MMSX_MAP_DEF_ID IN ( SELECT MPDF_MAP_DEF_ID  
FRO                                                            
M MAS_STYLE_LIST_MAP_DEF INNER JOIN MAS_MERCH_DIVISION ON      
MMDV_MERCH_DIV_ID = MPDF_MERCH_DIVISION_ID AND MMDV_BRAND_GRP_ID
= : H :                                                        
H AND MPDF_MERCH_SEASON_ID = : H : H AND MPDF_THEME_GRP = : H :
H ) AND MMSX_BATCH_PROC_STAT = 'UPDATED' AND MMSX_STATUS =      
'INACT                                                          
IVE' )                                                          

Problem Conclusion

Internally passed host variables passed may be different access
plan saved version.  This causes problems when processing this  
variables.  Problem may be seen when running an SQL UPDATE SET  
statement.  Problem has been fixed.                            

Temporary Fix

Comments

Circumvention

PTFs Available

R710 SI75298  1000

R720 SI64796  7290

R730 SI64962  7283

Affected Modules

Affected Publications

Summary Information

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, 2020, 2021, 2022, 2023, 2024 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