APAR status
Closed as program error.
Error description
Import of a TIMESTAMP WITH TIMEZONE column fails due to Unsupported data type error, but it should rather be imported as Unknown data type and succeed. Implemented the code change in DB2 Connector, so now TIMESTAMP WITH TIMEZONE column is getting imported with IMAM. It is marked as Unknown data type: CC_ODBCTYPE_UNKNOWN (also now seen in IMAM as (Unknown), not as (Unsupported).)
Local fix
Problem summary
Import with IMAM of a TIMESTAMP WITH TIMEZONE column fails due to Unsupported data type error, but it should rather be imported as Unknown data type and succeed.
Problem conclusion
Implemented the code change in DB2CC, so now TIMESTAMP WITH TIMEZONE column is getting imported with IMAM. It is marked as Unknown data type: CC_ODBCTYPE_UNKNOWN (also now seen in IMAM as (Unknown), not as (Unsupported)).
Temporary fix
Comments
APAR Information
APAR number
JR58187
Reported component name
INFO SRVR PLATF
Reported component ID
5724Q3612
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-07-21
Closed date
2017-08-11
Last modified date
2017-08-11
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
-
Fix information
Fixed component name
INFO SRVR PLATF
Fixed component ID
5724Q3612
Applicable component levels
RB50 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
11 August 2017