DB2 - Problembeschreibung
Problem IT28205 | Status: Geschlossen |
USER MIGHT RETRIEVE WRONG DATA FROM REMOTE ORACLE TABLES IF THE COLUMNS CONTAIN DATE TYPE AND THE DATA MIGHT BECOMES CORRECT AFT | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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'. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * **************************************************************** | |
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. | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : IT28084 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.02.2019 16.01.2020 16.01.2020 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version |