IBM Support

PI82437: ORACLE DATE COLUMN SAVED AS TIMESTAMP IN RIT DATABASE STUB

Fixes are available

Rational Performance Test Server 9.2
Rational Test Virtualization Server 9.2
Rational Integration Tester 9.2

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When IBM Rational Integration Tester (RIT) is learning a
database during stub creation, if the queries access tables
containing data of type DATE. the stub uses data type of
TIMESTAMP.

The table that is created in the stub schema will contain one or
more columns of type TIMESTAMP instead of type DATE.

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED:                                              *
* Users of Rational Integration Tester virtualizing Oracle     *
* database content that uses the DATE datatype.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* A database stub created from an Oracle table with a DATE     *
* column might result in the equivalent Oracle simulation      *
* database table using a TIMESTAMP for the column type.        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

    



Problem conclusion


    

  • In Rational Integration Tester 9.2 the virtual database schema
when using an Oracle database correctly honors the DATE
datatype.

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PI82437
    • 

  • Reported component name
    RATL INTEGRA TE
    • 

  • Reported component ID
    5725G79IT
    • 

  • Reported release
    910
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2017-06-01
    • 

  • Closed date
    2018-04-23
    • 

  • Last modified date
    2018-04-23
    • 





    

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

    • 

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

    • 



Fix information


    

  • Fixed component name
    RATL INTEGRA TE
    • 

  • Fixed component ID
    5725G79IT
    • 



Applicable component levels


    

  • R800  PSN
       UP
    • 

  • R801  PSN
       UP
    • 

  • R850  PSN
       UP
    • 

  • R851  PSN
       UP
    • 

  • R860  PSN
       UP
    • 

  • R870  PSN
       UP
    • 

  • R871  PSN
       UP
    • 

  • R900  PSN
       UP
    • 

  • R901  PSN
       UP
    • 

  • R910  PSN
       UP
    • 

  • R911  PSN
       UP
    • 

  • R920  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSBLQQ","label":"Rational Test Workbench"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB45","label":"Automation"}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            19 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback