JR58038: DB2 CONNECTOR FAILS TO DROP UNMATCHED UNBOUNDED STRING FIELD IN RCP MODE.

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 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