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