JR37351: ERROR SCENARIO CONNECTOR MIGRATION TOOL UPDATE STATEMENT AND DELETE

APAR status

• Closed as program error.

Error description

• Component Connector Migration Tool
  
  Error Scenario Connector Migration Tool Update Statement and
  Delete
  Option
  Error Description In a job that has 2 Connector migrations
  Connector
  Migration Tool incorrectly sets Oracle Update one correctly and
  the
  other Statement to the Delete Option
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Connector Migration Tool
  ****************************************************************
  PROBLEM DESCRIPTION:
  A job that contains Oracle Enterprise stage with upsert mode of
  'User-defined
  Update' does not map correctly to the Oracle Connector stage.
  
  
  ****************************************************************
  RECOMMENDATION:
  Install JR37351 patch.
  ****************************************************************
  

Problem conclusion

• A job with a Oracle Enterprise stage which has the write method
  set to 'Upsert' and
  the upsert mode set to 'User-defined Update' is not correctly
  migrated
  to the Oracle Connector stage.
  
  The Connector Migration Tool has been modified such that if the
  Oracle Enterprise
  stage has an upsert mode 'User-defined Update', the Oracle
  Connector will
  now have the 'Write Mode' set to 'Update'.
  

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