JR43118: DELETE/UPDATE WITH WHERE CURRENT OF CURSOR CLAUSE COULD OPERATE ON THE INCORRECT RECORD

DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• DELETE/UPDATE with WHERE CURRENT OF CURSOR clause could
  delete/update the wrong record. E.g.
  
  DECLARE cs1 CURSOR FOR SELECT col1 FROM nick1 WHERE col2 =
  'ABC'  AND NOT EXISTS (SELECT 1 FROM nick2 WHERE nick1.col3 =
  nick2.col3) FOR UPDATE
  OPEN cs1
  FETCH cs1
  DELETE FROM nick1 WHERE CURRENT OF cs1
  
  The DELETE could end up delete the wrong record in nick1.
  

Local fix

• Tuning the query to use query plan without sort or temp
  operation on ship.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * The user is running DELETE/UPDATE statement with WHERE       *
  * CURRENT OF CURSOR clause.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 Server V10.1 FP1.                             *
  ****************************************************************
  

Problem conclusion

• Firstly fixed in DB2 Server V10.1 FP1.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  JR43047

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  FEDERATED COMPI

• Fixed component ID

  5724N9702

Applicable component levels

• RA10 PSY

     UP