IBM Support

JR32594: DTS ENABLEMENT FOR TERADATA CONNECTOR IN VER 8.1

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as requirement.

Error description

  • DTS enablement for Teradata Connector in ver 8.1

Local fix

  • This fix is included in 8.0.1 fix pack 3

Problem summary

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • LIMITATIONS:

  - "Guranteed Delivery" does not support Atomicity. Data may
duplicate in the WebSphere MQ source
    queue and the target resource in the event of a failure.

  - When one of sort keys is Char or VarChar type and at least
one of the input links is associated
    with Teradata Connector, one of the following conditions
must meet.
    1. The key column of type Char or VarChar is a reserved
column. A reserved column is a column
       whose name starts with "DTS_" and is not associate with
a column in the target table.
    2. "Client character set" property of the Teradata
Connector link is compatible with NLS map.
       The following table shows the combinations of Client
character set and NLS map that are
       compatible.

       Client character set    NLS map
       -----------------------------------------
       UTF8         UTF-8
       ASCII         ASCII
       EBCDIC         IBM037
       EBCDIC037_0E        IBM037
       EBCDIC273_0E        IBM273
       EBCDIC277_0E        IBM277
       HANGULEBCDIC933_1II     IBM933
       HANGULKSC5601_2R4       KSC_5601
       KANJIEBCDIC5026_0I      IBM1026
       KANJIEUC_0U        EUC-JP
       KANJISJIS_0S        Shift_JIS
       LATIN1_0A        ISO-8859-1
       LATIN9_0A        ISO-8859-15
       LATIN1252_0A        windows-1252
       SCHGB2312_1T0        GB2312
       TCHBIG5_1R0        Big5
       TCHEBCDIC937_3IB        IBM937

  - When "Append node number" property  of the Distributed
Transaction Stage is "Yes",
    "Parallel synchronization" property of all links of
Teradata Connector must be "Yes".

    



APAR Information




    

  • APAR number
    JR32594
    • 

  • Reported component name
    WIS DATASTAGE
    • 

  • Reported component ID
    5724Q36DS
    • 

  • Reported release
    810
    • 

  • Status
    CLOSED  REQ
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2009-04-03
    • 

  • Closed date
    2009-05-22
    • 

  • Last modified date
    2010-12-10
    • 





    

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

    • 

  • 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":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            10 December 2010
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback