JR37965: DTS CONNECTOR TREATS RESERVED FIELDS AS UNUSED FIELDS AND STOPS THE JOB.

APAR status

• Closed as program error.

Error description

• When DTS Connector stage is configured to write records to
  Oracle database. The Drop unmatched fields property is set to
  No. The input link to the stage contains column that carries MQ
  message identifier, and whose data element attribute is set to
  WSMQ.MSGID.
  
  The job fails indicating that this column is unused. The DTS
  Connector should not count this column as unused for the Oracle
  operation, because this is a special column that is not
  intended for use by the Oracle statement but for the distributed
  transaction operation.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DataStage users who are utilizing DTS Connector stage in their
  jobs to write data to Oracle database in a distributed
  transaction.
  ****************************************************************
  PROBLEM DESCRIPTION:
  When the DTS Connector stage is used to write data to Oracle
  database, and the input link to the stage contains a reserved
  field (such as the field with Data element attribute set to
  WSMQ.MSGID), the connector does not ignore the reserved field
  but treats it as an unmatched field.
  
  Then if 'Drop unmatched fields' connector property is set to
  value 'No' the connector stops the job with a Fatal message
  indicating that the field was not utilized by the connector and
  that the connector was configured to stop the job in such a
  case.
  
  But since this field is a reserved field, the connector should
  ignore it regardless of what value was specified for the 'Drop
  unmatched fields' connector property.
  
  ****************************************************************
  RECOMMENDATION:
  Install patch JR37965.
  ****************************************************************
  

Problem conclusion

• The code in Oracle Connector was fixed to ignore fields marked
  as  reserved fields. The reserved fields are the field that have
  special purpose for the DTS processing, which is indicated by
  the Data element attribute of the fields. For example a field
  with the Data element attribute set to WSMQ.MSGID is reserved
  field in the context of a DTS job.
  
  With the fix in place the connector ignores the reserved fields
  on the input link. It does not fail the job or report them as
  unmatched fields any more.
  
  The fix is in the Oracle Connector library. Note that the Oracle
  Connector library is utilized behind the scene by the DRS
  Connector stage configured for Oracle database access.
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP