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