JR53877: DB2 Connector wrongly interprets unsigned INT8 input column as signed INT8 when Runtime Column Propagation (RCP) is used.

IBM InfoSphere Information Server, Version 11.5.0.1 (Fix Pack 1)

APAR status

• Closed as program error.

Error description

• When upserting with DB2 Connector using Runtime Column
  Propagation, uint8 is converted into int8 causing error
  messages when numeric input data overpass 128.
  

Local fix

• Use a modify operator to reference each TINYINT SQL Columns as
  : MyColumn:int16=MyColumn in order to match directly the DB2
  Datatype for tinyint (smallint).
  

Problem summary

• When DB2 Connector uses Runtime Column Propagation, uint8 is
  converted into int8 while inserting numeric data larger than
  127. This results in job failure with an error message.
  During schema reconciliation, sign attribute for the negotiated
  schema was taken from external schema though it should be taken
  from design schema.
  

Problem conclusion

• A patch was published, which introduces environment variable
  CC_USE_DESIGN_SCHEMA_ATTRIBUTE to switch the schema
  reconciliation behavior. When the environment variable
  CC_USE_DESIGN_SCHEMA_ATTRIBUTE=1 is set, the sign attribute for
  numeric data types is taken from design schema rather than
  database schema. The environment variable applies to ODBC
  Connector, Oracle Connector, Teradata Connector, DRS Connector,
  Netezza Connector, and Greenplum Connector as well as DB2
  Connector.
  

Temporary fix

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

  INFO SRVR PLATF

• Fixed component ID

  5724Q3612

Applicable component levels

• RB30 PSY

     UP

• RB31 PSY

     UP