Fixes are available
APAR status
Closed as program error.
Error description
Performance of ODBC-Connector is significantly low, when ODBC-Connector is connecting MSSQL-Server and executing insert/update statements on the table which has index-varchar-column and other varchar columns has accented(multi-byte) data in it.
Local fix
Problem summary
Performance of ODBC-Connector is significantly low, when ODBC-Connector is connecting MSSQL-Server and executing insert/update statements on the table which has index-varchar-column and other varchar columns has accented(multi-byte) data in it.
Problem conclusion
Fixed, after installing the patch, customer's job would with good performance. And also customer need to set environment variable CC_ODBC_BIND_AS_VARCHAR=1.
Temporary fix
Comments
APAR Information
APAR number
JR61567
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B70
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-10-03
Closed date
2019-10-23
Last modified date
2019-10-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
OCBC-CC
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
RB50 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 October 2021