APAR status
Closed as program error.
Error description
There is a defect in the ODBC driver that was updated in 2018.4.1.20 / 10.0.1.7 that causes the binding of an assigned parameter to fail to convert the time data (specifically in TO_TIMESTAMP_TZ()). This issue is being addressed by the ODBC driver team whom will provide a fix in the form of a driver that will be added in to the DataPower fixpacks.
Local fix
Use the data type "TIMESTAMP(6) WITH TIME ZONE" instead to work-around the behavior.
Problem summary
The ODBC driver has been updated to fix the error.
Problem conclusion
The fix will be in 10.0.1.10 & 2018.4.1.23 For a list of the latest fix packs available, please see: https://www.ibm.com/support/pages/node/83105
Temporary fix
Comments
APAR Information
APAR number
IT42051
Reported component name
DATAPOWER
Reported component ID
DP1234567
Reported release
A0X
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-09-15
Closed date
2022-10-24
Last modified date
2022-10-24
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
DATAPOWER
Fixed component ID
DP1234567
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateways"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A0X","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
25 October 2022