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 number
JR37965
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-10-12
Closed date
2010-10-25
Last modified date
2010-10-25
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
[{"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":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
25 October 2010