DB2 FOR LUW / DB2FORLUW / A50 - DB2

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'.

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

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.

not known / see Local fix

forerunner  : IT28084 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

23.02.2019
16.01.2020
16.01.2020