APAR status
Closed as program error.
Error description
Get fatal error message of type nullDate,0: Data string '01/01/1900' does not match format '%yyyy-%mm-%dd': the value for tag %yyyy has fewer characters than expected." When reading NULL Date using DB2 EE operator. NOTE the final status of the Job is Finished (with warnings).
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: The issue is seen when DB2 EE is used on IS 801 FP1 **************************************************************** PROBLEM DESCRIPTION: The following error is thrown when DB2 EE is used to read null dates from a table: Data string '01/01/1900' does not match format '%yyyy-%mm-%dd': the value for tag %yyyy has fewer characters than expected." **************************************************************** RECOMMENDATION: The issue may be fixed by installing patch_JR31558 ****************************************************************
Problem conclusion
This has been fixed in DB2 EE and a patch is available in IS 801 FP1
Temporary fix
Comments
APAR Information
APAR number
JR31558
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-12-24
Closed date
2009-01-16
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
DB2 EE
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010