IBM Support

IT28205: USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE COLUMNS CONTAIN DATE TYPE AND THE DATA MIGHT BECOMES CORRECT AFT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE
    COLUMNS CONTAIN DATE TYPE AND THE DATA MIGHT BECOMES CORRECT AFT
    
    Root cause:
    Oracle client (OCI) doesn't send "ALTER SESSION" command which
    is to set the DATE data format immediately after connection with
    the environment variable NLS_DATE_FORMAT set to 'YYYY-MM-DD
    HH24:MI:SS'.
    

Local fix

  • Explicitly send "ALTER SESSION" command to Oracle server
    immediately after connection is setup. So that the DATE data
    format is set to what federation server understands before
    remote data query of DATE type.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28205

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-23

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

    IT28084

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 May 2022