JR38707: CONNECTORS SHOULD LOG SQL STATEMENTS AND VALUES AT POINT OF FAILURE

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as new function.

Error description

• ? When a connection cannot be established, include in the log
  the name of the database (or other resource) being accessed, and
  the username being used.   These should be logged along with the
  failure message from the resource.
  
  ? When a SQL statement fails, log the relevant column values
  associated with the SQL statement.  This is most useful when the
  database returns ?duplicate key? or ?invalid value? error
  messages.  At a glance of the log, the user can then see what
  values resulted in the error.  Logging of values will be
  disabled by default, but may be enabled by setting a property.
  An additional property will determine whether to log the values
  of all columns or just those identified by key columns.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 Connector, ODBC Connector, Oracle Connector and Teradata
  Connector users
  ****************************************************************
  PROBLEM DESCRIPTION:
  Enhance connectors to log the values in each column when a row
  fails to be inserted, updated or deleted.
  ****************************************************************
  RECOMMENDATION:
  Apply patch JR38707
  ****************************************************************
  

Problem conclusion

• The DB2, ODBC, Oracle and Teradata Connectors have been enhanced
  to log the values in each column when a SQL statement fails to
  write data. Each connector now has a new category of properties
  called "Logging".  The following properties have been added
  under the Logging category:
   - Log column values on first row error: This property specifies
  whether the connector logs column values for the first row that
  failed on each node. Set this property to Yes to enable the new
  functionality. The default value is No. Since this functionality
  is not available when bulk loading, this property is disabled
  for the DB2 and Teradata Connectors when their Write mode
  property is set to Bulk load.
   - Log key values only: This property is a sub-property of "Log
  column values on first row error" and specifies whether the
  connector logs the values of all columns or only key columns.
  Set this property to Yes to restrict logging to key column
  values.
   - Column delimiter: This property is a sub-property of "Log
  column values on first row error" and specifies the delimiter
  used between column values in the log. Options are Space,
  Newline, Tab and Comma. The default value is Space.
  
  Note that the error messages shown when an error occurs
  connecting to the database have also been improved.
  
  
  Refer to the technote at
  https://www.ibm.com/support/docview.wss?uid=swg21468823 for
  more information.
  

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 PSY

     UP

• R850 PSN

     UP