MA46475 - OSP-DB-OTHER FILE WITH AUX SPACE BECOMES DAMAGED.

Abstract

OSP-DB-OTHER FILE WITH AUX SPACE BECOMES DAMAGED.

Error Description

File with AUX space becomes damaged.                            

Problem Summary

When a file contains large variable length fields (BLOB, CLOB,  
etc) and there is one or more jobs reading from the file at the
same time one or more jobs are inserting into the end of the    
file, it is possible that one of the reader jobs may detect a  
mismatch between the fixed length portion of the record and the
variable length portion of the record.  This occurs because, in
rare instances in the insert path, the code determines that it  
needs to extend an internal structure housing location          
information.  Unfortunately the serialization used when        
extending this structure is not sufficient enough to prevent a  
reader job from seeing the structure in flux, thus causing the  
mismatch.  This results in a read error, a 0600 5EED vlog, and  
the file being marked damaged.  Although in actually, if the    
read is tried again to the same record, it will be successful.  
                                                               
It should be noted that no data is lost or corrupted and all    
records can be read successfully and correctly once the internal
structure is no longer in flux.  The file is not actually      
damaged and was marked damage in error.                        

Problem Conclusion

This PTF enforces more strict serialization when these internal
structures are being extended so that NO other job or task will
see the structures while they are in flux, thus a reader job    
would neve find the structure in flux and would find the correct
VL data.                                                        
                                                               
As noted in the problem description When the structure is not in
flux, all reads are correct and successful.  The file was marked
damaged in error.  However, this PTF will NOT unmark the file.  
Service must be contacted to have the damage indication        
reversed.                                                      

Temporary Fix

                       *********                                
                       * HIPER *                                
                       *********                                

Comments

Circumvention

PTFs Available

R710 MF68659  1000

R720 MF63831  7290

R730 MF63832  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 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