home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC78787 Status: Closed

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

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
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 #1 - about 64K of '---' is being appended to the end of 
the DDL statement 
 
 DDL: OFFLINE LOAD DEL AUTOMATIC INDEXING INSERT COPY YES 
REGRES2 .<object_name>, CPU_PARALLELISM [4], DISK_PARALLELISM 
[2], DATA BUFFER [0], TEMPFILES PATH 
[***DBDIR***/***LOAD_TEMPFILES_PATH***], DUMPFILE [none] 
< 
--- 
>  DDL: [LOADID: 1634.****-**-**-**.**.**.******.0 (2;6)] 
[*LOCAL.regres2.110813085450] OFFLINE LOAD DEL AUTOMATIC 
INDEXING INSERT COPY YES REGRES2 .<object_name>, CPU_PARALLELISM 
[5], DISK_PARALLELISM [2], DATA BUFFER [0], TEMPFILES PATH 
[***DBDIR***/***LOAD_TEMPFILES_PATH***], DUMPFILE 
[none----------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
----------(and 
so on..............................................for about 
64K) 
 
 
Problem #2 - additional info is added to what seems like ALL 
tablespace statements (create and alter) 
 
 
DDL: alter tablespace <tablespace_name> ADD (FILE '<name>' 500) 
extentsize 64 
< 
--- 
>  DDL: alter tablespace <tablespace_name> ADD (FILE '<name>' 
500) extentsize 6<garbage>.CHARACTER_DATA, CPU_PARALLELISM [5], 
DISK_PARALLELISM [2], DATA BUFFER [0], TEMPFILES PATH 
[***DBDIR***/***LOAD_TEMPFILES_PATH***], DUMPFILE [nonE 
[n-------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
-----<garbage> 
 
 
 
Problem #3 - truncations in the middle of the DDL string (in 
this case 2 truncations) 
 
(this first truncation was there in the 110731 build) 
< DDL: create tablespace <tablespace_name> managed by database 
using***TESTDIR***513_1/tbs/DBJPCMD/93' 500) extentsize 64 
< 
--- 
>  DDL: create tablespace <tablespace_name> managed by database 
using***TESTDIR***513_1/tbs/DBJPCMD/93' 500) extentsize 6entsize 
6HARACTER_DATA, CPU_PARALLELISM [4], DISK_PARALLELISM [2], DATA 
BUFFER [0], TEMPFILES PATH 
[***DBDIR***/***LOAD_TEMPFILES_PATH***], DUMPFILE [nonE 
[n-------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
---------------------------------------------------------------- 
--------------- 
 
 
 
 
Problem #4 - tablespace name is missing 
 
Expected: (even though it contains garbage characters, at least 
we have a tbsp name) 
 
  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 Summary:
**************************************************************** 
* 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 v97fp5 or later versions                          * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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

Solution
problem fixed.
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC79815 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.09.2011
30.11.2011
30.11.2011
Problem solved at the following versions (IBM BugInfos)
9.7.FP5
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.5 FixList