DB2 FOR LUW / DB2FORLUW / 970 - DB2

The following LOAD command fails with SQL0180 on valid 
TIMESTAMP values in the LOAD file: 
db2 "LOAD FROM t1.asc OF ASC METHOD L (1 19) INSERT INTO t1" 
 
Where table t1 contains one TIMESTAMP column: 
db2 "CREATE TABLE t1 (c1 TIMESTAMP)" 
 
And LOAD file t1.asc contains valid TIMESTAMP values on each 
row: 
2010-03-04-10.05.00 
...

USERS AFFECTED: All 
 
PROBLEM DESCRIPTION: 
 
See ERROR DESCRIPTION 
 
PROBLEM SUMMARY: 
 
See ERROR DESCRIPTION

* Use delimited ASCII file format for the LOAD file 
* Add MODIFIED BY TIMESTAMPFORMAT="YYYY-MM-DD-HH.MM.SS" to the 
  LOAD command 
* Pad the timstamp values in the LOAD file with blanks up tp the 
  form "YYYY-MM-DD-HH.MM.SS.UUUUUU", and modify the METHOD L 
  byte offsets accordingly

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 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 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 Fix Pack 2

See LOCAL FIX.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC67130 IC67173 
Nachfolger : 

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

04.03.2010
08.06.2010
08.06.2010

9.7.FP2