APAR status
Closed as program error.
Error description
When importing a type tree using the Database Interface Designer from a DB2 instance hosted on z/OS, if the database is set to ISO, then the item properties may be created with incorrect delimiters for the TIME and TIMESTAMP columns. The type tree item properties for a DB2 TIME column are created as HH24:MM:SS with colon character ( : ) as the delimter but the WTX engine receives the data from DB2 as HH24.MM.SS with a dot or period character ( . ) as the delimiter. The type tree item properties for a DB2 TIMESTAMP column are created as {CCYY-MM-DD}[ {HH24:MM[:SS[.6-6]]}] with a space character as the delimter between the date and time and a colon character ( : ) as the delimter for the time portion. The WTX engine receives the data from DB2 for the TIMESTAMP as {CCYY-MM-DD}[-{HH24.MM[.SS[.6-6]]}] which uses a hyphen character ( - ) as the delimter between the date and time and a dot or period character ( . ) as the delimiter for the time portion.
Local fix
WTXCQ - WTX00041455 PB / PB Circumvention: Manually modify the type tree properties.
Problem summary
Users Affected: WebSphere Transformation Extender z/OS users that require type tree generation with an "ISO" date&time format Problem Description: The DB Interface Designer's type tree generator does not automatically handle the z/OS "ISO" time and timestamp column format. Platforms Affected: Design Time - Windows Run Time - z/OS
Problem conclusion
The DB Interface Designer can import TIME and TIMESTAMP columns from a z/OS DB2 DBMS with the "ISO" format. Before this fix, only the z/OS "JIS" format was supported, which then required customers with ISO-based z/OS configurations to perform manual type tree overrides. By defining the following environment variable, set WTX_ADAPTER_DB2_DATETIME_FORMAT=ISO, the correct WTX date&time stamp type tree will get automatically generated. Delivered in: 8.3.0.6, 8.4.0.4
Temporary fix
Comments
APAR Information
APAR number
PM73697
Reported component name
WSTX
Reported component ID
5724M4000
Reported release
840
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-09-26
Closed date
2012-10-26
Last modified date
2014-05-12
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WSTX
Fixed component ID
5724M4000
Applicable component levels
R820 PSY
UP
R830 PSY
UP
R840 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSD8","label":"IBM Transformation Extender"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.4","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
12 May 2014