IBM Support

JR25953: SQL-BASED REPLICATION, SUBSCRIPTION ON MSSQL TARGET DOES FAILS IF COLUMN TYPE IS VARCHAR

Fixes are available

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

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the source column is of VARCHAR type, and if you
attempt to create a subscription in SQL Replication env,
and if target table does not exist on MSSQL  server,
The SQL generated script will create the target table
and maps the column type varchar to text.

Local fix

  • na

Problem summary

  • AS DESC IN THE APAR

Problem conclusion

  • FIXED IN API

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR25953
    • 

  • Reported component name
    WS Q-REPLIC LUW
    • 

  • Reported component ID
    5724N9801
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2007-02-14
    • 

  • Closed date
    2008-08-08
    • 

  • Last modified date
    2008-08-08
    • 





    

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

    
GG04729
    

    • 

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

    • 



Fix information


    

  • Fixed component name
    WS Q-REPLIC LUW
    • 

  • Fixed component ID
    5724N9801
    • 



Applicable component levels


    

  • R910  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.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            07 January 2022
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback