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 IC79815 Status: Geschlossen

LIST HISTORY ALL SHOWS MISSING COMMENTS AND TABLESPACE NAMES WHEN DBCS ARE
INVOLVED

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
When list history command is executed in CLP either in jp or tw 
locale with 
server in different codepage, the o/p may contain missing 
comments and tablespace names. Also, there could be garbage data 
appended to the o/p when there are DDLs as part of the history 
o/p. 
 
for e.g: 
Client: 
DB2CODEPAGE=954 
DB2COUNTRY=81 
AIXLOCALE=ja_JP 
LC_ALL=ja_JP 
 
Server: 
codepage = 932 
 
 
 
 
Problem #- tablespace name is missing 
 
Expected: 
 
  00001 <tablespace_name> 
 
 --------------------------------------------------------------- 
------------- 
    Comment: CREATE TABLESPACE, ID = 6 
 Start Time: ************** 
   End Time: ************** 
 --------------------------------------------------------------- 
------------- 
  EID: ***** Location: 
 
 
Currnently: 
 
  00001 
---------------------------------------------------------------- 
------------ 
    Comment: CREATE TABLESPACE, ID = 6 
 Start Time: ************** 
   End Time: ************** 
 --------------------------------------------------------------- 
------------- 
  EID: ***** Location: 
 
Problem#-Comments missing 
Instead of: 
              Comment:  <my dbcs comments> 
              Start Time:  ...... 
 
        Current result: (wrong, as its missing the comment 
completely) 
              Comment:   Start Time: ........
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* db2 clp users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* list history might show corrupted o/p whenever data          * 
* conversion is required between client and server.            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to v95fp9 or later versions                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
problem fixed.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
15.11.2011
08.03.2012
08.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList