IBM Support

SE67742 - OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGMCH3402 MCH3402 QDBCHGFI
VFY_LGL_DEPENDENTS #DOMTPTRX SQL0901 MCH1210 LOCK_SPANNING_VIEWS

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.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 APAR (Authorized Program Analysis Report)

Abstract

OSP-DB-OTHER-F/QDBCHGFI-T/QDBCHGFI-MSGMCH3402 MCH3402 QDBCHGFI
VFY_LGL_DEPENDENTS #DOMTPTRX SQL0901 MCH1210 LOCK_SPANNING_VIEWS

Error Description

2 ALTER TABLE statements fail with a MCH3402 from QDBCHGFI      
followed by a SQL0901.                                          
An error message MCH1210 can be found ahead.                    
We are unable to get the lock so we keep retrying.              
The 32,768th retry hits the limit on a BIN(15) field and causes
the MCH1210 which finally leads to the MCH3402 errors.          

Problem Summary

Concurrent ALTER TABLE statements fail with a MCH3402 from      
QDBCHGFI followed by a SQL0901.  An error message MCH1210 can be
found ahead.                                                    

Problem Conclusion

This problem can occur when multiple concurrent ALTER TABLE    
statements are running.  The tables being altered have common  
dependent view.   Timing of the ALTER TABLE can result in a    
deadlock situation that eventually results in the MCH1210.      
Subsequent ALTER TABLE statements may result in the MCH3402    
exception.                                                      
                                                               
This ptf is preventative.  Dependent views need to be deleted  
for tables that failed with the MCH3402.                        

Temporary Fix

Comments

Circumvention


PTFs Available

R720 SI65491 PTF Cover Letter   8032
R730 SI65490 PTF Cover Letter   8025

Affected Modules

         
         

Affected Publications

Summary Information

Status............................................ CLOSED PER
HIPER........................................... No
Component.................................. 5770SS1DB
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

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.2.0"},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG15Q","label":"APARs - OS\/400 General"},"Component":"","ARM Category":[],"Platform":[{"code":"PF012","label":"IBM i"}],"Version":"V7R1M0;V7R2M0;V7R3M0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 March 2018