JR58006: DB2 CONNECTOR: NO GENERATION OF EVENTS FOR OPERATIONAL METADATA DEPENDING ON SQL PROVIDED AS PARAMETER

APAR status

• Closed as program error.

Error description

• A DB2 Connector includes a  user-defined SELECT statement
  included a WHERE with the WHERE provided as job parameter.
  This DB2 Connector could not generate the informaton linked to
  this SELECT in the event file for the Operational Metadata for
  a job run.
  This was the case for the value of the  job parameter as
  "(1=1)".
  

Local fix

• Change the user defined SELECT to not include control
  characters in the job parameter value.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users wishing  to generate Operational Metadata XML event on
  user defined SQL queries
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2 connector does not generate table information for events in
  Operational Metadata XML. As a result, lineage is not available
  for the DB2 connector job.
  
  DB2 Connector does not generate locator information for
  Operational Metadata XML when a complex user-defined SQL is
  used, for example with sub-select statements or join clauses.
  The problem occurs also when user-defined SQL uses job
  parameters to parametrize not only column values, but larger
  parts of the query, for example:
  SELECT * FROM TABLE_A WHERE #PARAM#
  PARAM = "TABLE_A.COLUMN_B = 'something'"
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR58006.
  ****************************************************************
  

Problem conclusion

•  Problem is caused by the fact that SQL builder does not return
  information about tables that the user-defined SQL operates on,
  so DB2 connector passed an empty table list to the Operational
  Metadata XML.
  DB2 connector code has been changed to parse user-defined SQL
  queries to retrieve the working table list without relying on
  SQL builder.
  

Temporary fix

• n/a
  

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

• R912 PSY

     UP

• RB31 PSY

     UP

• RB50 PSY

     UP