IBM Support

JR46321: CDC CANNOT DELETE ROWS IN TABLES WITH RECURSIVE REFERENTIAL INTEGRITY CONSTRAINTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • CDC will process the DELETE in the order recorded on the log.
When running DELETE, the DELETE for the parent gets recorded
first, and therefore, CDC will replicate this DELETE first and
it getting the error.

Therefore, if the order of DELETEs in the log does not respect
the child - parent relationship, then CDC has not way of
handling it.

Local fix

  • The only real solution in the short to medium term is to disable
referential integrity.

Problem summary

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • This enhancement request should be pursued through RFE
(http://www.ibm.com/developerworks/rfe/?BRAND_ID=184).

    



APAR Information




    

  • APAR number
    JR46321
    • 

  • Reported component name
    IS CDC ORACLE
    • 

  • Reported component ID
    5724U7008
    • 

  • Reported release
    651
    • 

  • Status
    CLOSED  SUG
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-04-10
    • 

  • Closed date
    2013-04-11
    • 

  • Last modified date
    2013-04-11
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    
JR43179
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    



Applicable component levels


    








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"651","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                                                                    

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            11 April 2013
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback