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