home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC86076 Status: Geschlossen

CLP & CLI NOT PERFORMING CODE PAGE CONVERSION ON DATE, TIME AND
TIMESTAMP VALUES FROM ZOS when IDAA Query Acceleration is enable

Produkt:
DB2 CONNECT / DB2CONNCT / 970 - DB2
Problembeschreibung:
When using IDAA (DB2 Analytics Accelerator) with DB2 for z/OS 
and QUERY ACCELERATION = ENABLE is set, then the values of date, 
time and timestamp columns are not displayed correctly by either 
CLP or CLI clients. This issue is with all non-JAVA clients. 
 
Here is an example query and its output when IDAA query 
acceleration is enabled: 
 
select birth_date, count(*) from sample.personnel for fetch only 
    BIRTH_DATE 
    ----------       ----------- 
    ...??..??.       20199 
    ...??..??        6028 
    .?.?..??.        337 
 
The problem does not occur when IDAA QUERY ACCELERATION = NONE 
is set.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* When C-client is used to access IDAA.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v97fp7 or later releases.                     * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
db2_v97fp7 contains fix of this issue. After fix, the date data 
will display in correct format.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC86358 IC88670 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.08.2012
24.10.2012
28.11.2013
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.7 FixList