IT48967: MISSING WHERE CLAUSE IN DATABASE UPDATE CAUSES ALL ROWS IN A TABLE TO BE LOCKED

APAR status

• Closed as program error.

Error description

• The SQL submitted to a database is missing the WHERE clause that
  is in the ESQL written for the node. The lack of the WHERE
  clause causes all rows in the table to be locked for update
  impacting performance.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus v10.1, App Connect Enterprise
  v12 and App Connect Enterprise v13 who use a database WHERE
  clause that includes sections that are evaluated internally by
  ACE or IIB, and sections that are evaluated by the database.
  
  
  Platforms affected:
  AIX, WinX64, LinuxZ64, LinuxPPCLE64, LinuxX64
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  For example example an ESQL statement like this "UPDATE
  Database.my_table AS A SET x = 123456 WHERE A.y = 987654 AND A.z
  = my_max_value();"
  my_max_value() is an ESQL procedure.
  In a
  statement of this form where my_max_value() is evaluated by
  ACE/IIB the whole WHERE clause is never sent to the database.
  The missing WHERE clause may then lead to a loss of performance
  when updating the database due to excessive row locking in the
  table. This is especially noticeable if the table has a large
  number of rows.
  

Problem conclusion

• The SQL code, generated from the ESQL code in the node, which is
  sent to the database has been amended to prevent this happening.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version   Maintenance Level
  v10.1      10.1.0.7
  v12.0      12.0.12.25
  v13.0      13.0.7.0
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

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

  APP CONNECT ENT

• Fixed component ID

  5724J0560

Applicable component levels