JR29511: PATCH REQUEST OF ECASE#103588/110468 FOR DB2 EE STAGE

APAR status

• Closed as program error.

Error description

• The customer gets the following error message from the lookup
  stage w/ DB2 EE stage:
  Error Message :
  Sequential_File_42: Error when checking operator: Could not find
  input field "A".
  
  This problem seems a regression issue on DS 753. We found the
  following similar issues using Oracle and ODBC stages:
  ECASE 103588: Lookup is sending ouputdata based on column names
  and not on derivation
  ECASE 110468: OdbcLookup:Jobs with secondary link fields to
  output are getting finished with no data in the output
  
  We recreated the subject issue on AIX. If the problem occurred
  on any UNIX platform,
  could you please provide us with the patches for all Unix
  platforms?
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using DB2 Enterprise Stage
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  Bad results of DB2 EE stage with sparse lookup
  The customer gets the following error message from the lookup
  stage w/ DB2 EE stage:
  Error Message :
  Sequential_File_42: Error when checking operator: Could not find
  input field "A".
  
  ****************************************************************
  RECOMMENDATION:
  Apply patch for JR29511
  
  ****************************************************************
  

Problem conclusion

• Lookup is sending ouputdata based on column names and not on
  derivation DataStage seems to ignore the source/target mapping
  when the output column name matches the input column name. the
  output column "A"
  is taking the data from the input column "A", instead of
  using the derivation defined.
  
  Fixed the DB2EE code to take the data from derivation defined.
  

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:

Modules/Macros

• DB2
  

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R753 PSN

     UP