DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2BATCH returns wrong fraction part for TIMESTAMP values. 
 
Following steps will reproduce the issue: 
 
create table t (testno INTEGER , testtime TIMESTAMP ); 
insert into t values ( 1 , '2011-04-01 00:00:01.000001' ); 
insert into t values ( 2 , '2011-04-01 00:00:01.000010' ); 
insert into t values ( 3 , '2011-04-01 00:00:01.000123' ); 
insert into t values ( 4 , '2011-04-01 00:00:01.001234' ); 
select * from t order by testtime asc ; 
 
 
Output when running SELECT with db2 clp is correct: 
 
TESTNO      TESTTIME 
----------- -------------------------- 
          1 2011-04-01-00.00.01.000001 
          2 2011-04-01-00.00.01.000010 
          3 2011-04-01-00.00.01.000123 
          4 2011-04-01-00.00.01.001234 
 
 
But running db2batch -d sample -f b.sql (contains "select * from 
t order by testtime asc ;"): 
 
* SQL Statement Number 1: 
select * from t order by testtime asc ; 
 
TESTNO      TESTTIME 
----------- -------------------------- 
          1 2011-04-01 00:00:01.001000 
          2 2011-04-01 00:00:01.010000 
          3 2011-04-01 00:00:01.123000 
          4 2011-04-01 00:00:01.1234000

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

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
 

First fixed in Version 9.7 Fix Pack 5.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.05.2011
12.12.2011
12.12.2011

9.7.FP5