DB2 FOR LUW / DB2FORLUW / 970 - DB2

The issue is described below: 
 
1- DB2BATCH output on  previous DB2 version  in this case "DB2 
v9.7.0.3" 
 
select distinct trim(col1) from t1 fetch first 10 rows only ; 
 
1 
------------------------------ 
0 
0000512 
001 
00103 
00105 
00107 
00108 
00112 
00113 
00118 
 
2-DB2BATCH output  on "DB2 v9.7.0.8" 
 
select distinct trim(col1) from t1 fetch first 10 rows only ; 
 
1 
---------------------------------------------------------------- 
-------------------------------------------------------- 
0 
0000512 
001 
00103 
00105 
00107 
00108 
00112 
00113 
00118 
 
4- If the SELECT is executed on CLP the header output is the 
same on both FPs 
 
- FP3 
$ db2 "select distinct trim(col1) from t1 fetch first 10 rows 
only" 
 
1 
------------------------------ 
0 
0000512 
001 
00103 
00105 
00107 
00108 
00112 
00113 
00118 
 
 
- FP8 
 
db2 "select distinct trim(col1) from t1 fetch first 10 rows 
only" 
 
1 
------------------------------ 
0 
0000512 
001 
00103 
00105 
00107 
00108 
00112 
00113 
00118 
 
In this example the db2batch header size is 30 on v9.7fp3 and on 
v9.7fp8 is 120. On CLP the header size is 30 on both version.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10                       * 
****************************************************************

As workaround you can use the option "-w" in the db2batch 
command. This option specifies 
the maximum column width of the result set.

First fixed in DB2 Version 9.7 Fix Pack 10

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

05.05.2014
10.11.2014
28.05.2015

9.7.FP10