IBM Support

JR37745: REPLICATION ADMIN FIXES FOR DB2 LUW V97 FP3A

Fixes are available

DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • 



Local fix


    

  • 



Problem summary


    

  • .
The following Replication Server admin defects have been
fixed in DB2 LUW V97 FP3a:
.
wsdbu00780932
Problem Summary: Behavior of federated targets is
 inconsistent with DB2 targets containing scalar
 expressions, constant value expressions are not
 recognized as valid input.
Fix Details: Enable the Replication Center to allow
 federated target columns to be mapped with a constant
 value expression.
.
wsdbu00782115
Problem Summary: If there is an error in issuing the
 series of SQL statements to define one or more
 subscriptions, there is no roll-back
Fix Details: Set the DatabaseUpdate rollback flag so the
 operation is rolled back when the operation that has an
 error is closed.
.
wsdbu00757534
Problem Summary: Replication Center does not create the
 cd tablespace with the source tablespace CCSID which
 causes invalid data due to conversion when the table is
 replicated.
Fix Details: We check the source CCSID and use it for the
 CD tablespace now, instead of using the CCSID of the UOW
 tables by default.
.

    



Problem conclusion


    

  • see above

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR37745
    • 

  • Reported component name
    WS Q-REPLIC LUW
    • 

  • Reported component ID
    5724N9801
    • 

  • Reported release
    970
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2010-09-10
    • 

  • Closed date
    2010-11-03
    • 

  • Last modified date
    2010-11-03
    • 





    

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

    • 

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

    
IC71226
    

    • 



Fix information


    

  • Fixed component name
    WS Q-REPLIC LUW
    • 

  • Fixed component ID
    5724N9801
    • 



Applicable component levels


    

  • R970  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            12 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback