IBM Support

JR58276: SUPPORT OF TIMESTAMP WITH TIMEZONE DATATYPE IN DB2 CONNECTOR, TREAT AS VARCHAR

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as suggestion for future release.

Error description

  • Implemented the code change in DB2CC, so now TIMESTAMP WITH
TIMEZONE column is getting imported to IMAM and Datastage
Client as VARCHAR datatype.
When fetching from and writing to TIMESTAMP WITH TIMEZONE type
column with a DB2 Connector job, the column is treat as VARCHAR
datatype.

Local fix

  • 



Problem summary


    

  • 



Problem conclusion


    

  • 



Temporary fix


    

  • 



Comments


    

  • Implemented the code change in DB2CC, so now TIMESTAMP WITH
TIMEZONE column is getting imported to IMAM and Datastage Client
 as VARCHAR datatype.
When fetching from and writing to TIMESTAMP WITH TIMEZONE type
column with a DB2 Connector job, the column is treat as VARCHAR
datatype.

Recommendation:
Install IIS 11.7.

    



APAR Information




    

  • APAR number
    JR58276
    • 

  • Reported component name
    INFO SRVR PLATF
    • 

  • Reported component ID
    5724Q3612
    • 

  • Reported release
    B50
    • 

  • Status
    CLOSED  SUG
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2017-08-10
    • 

  • Closed date
    2017-12-18
    • 

  • Last modified date
    2017-12-18
    • 





    

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

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            18 December 2017
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback