APAR status
Closed as program error.
Error description
DB2 connector fails to drop unmatched unbounded string field in RCP mode.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Users of DB2 connector running DataStage jobs with following conditions: - Runtime Column Propagation enabled - DB2 connector used as target (writing data to DB2 database) - Drop unmatched fields enabled in DB2 connector - Stage with RCP schema file (i.e. Sequential File, Row Generator) contains additional, unmatched text fields (compared to DB2 connector) without specified length (unbounded) **************************************************************** PROBLEM DESCRIPTION: DB2 connector, with 'Drop unmatched fields' option enabled, used as target in Runtime Column Propagation mode may fail if source stage is configured using schema file containing additional unbounded text fields - not matching DB2 table columns and without length specified. Error reported in DB2 connector DataStage job: Failed to convert string (CC_StringConverter:: toUnicode, file CC_StringConverter.cpp, line 329) **************************************************************** RECOMMENDATION: Install APAR JR58038 patch. ****************************************************************
Problem conclusion
Problem was caused by an attempt to initialize a string variable with negative length when DB2 connector was processing unmatched fields. DB2 connector code has been changed to resolve the problem. For unmatched input text fields with undefined length, a default length of 1024 characters has been introduced. Users can alter the default text field length by setting CC_DB2_UNBOUNDED_STRING_LENGTH environment variable to the desired value.
Temporary fix
N/A
Comments
APAR Information
APAR number
JR58038
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-06-26
Closed date
2017-09-15
Last modified date
2017-09-15
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
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":"IBM InfoSphere DataStage"},"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:
15 September 2017