PI74349: DB2Z SHOULD BE BLOCKING MERGE ON AOTS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Doing a MERGE on AOTs ( AOT Accelerator Only Table ), get a
  successful SQL completion (but an empty table). DB2z should be
  blocking MERGE on AOTs.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS users of QUERY              *
  *                 ACCELERATION for Accelerator-Only tables     *
  *                 (AOTs) and the SQL MERGE statement.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQL MERGE INTO a target table that   *
  *                      is an Accelerator-Only Table ( AOT )    *
  *                      incorrectly results in a successful     *
  *                      SQL completion, even though a MERGE on  *
  *                      the AOT did not actually occur.         *
  *                      Instead, DB2 should not allow an SQL    *
  *                      MERGE INTO an AOT.                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An SQL MERGE INTO a target table that is an Accelerator-Only
  Table (AOT) incorrectly results in a successful SQL completion
  even though a MERGE on the AOT did not actually occur. Instead,
  DB2 should not allow an SQL MERGE INTO an AOT, but fail the
  MERGE with an SQLCODE -4742 and reason-code 22.
  

Problem conclusion

• DB2 processing for the SQL MERGE INTO statement has been
  modified to issue SQLCODE -4742 reason-code 22 when the
  target table of the MERGE is an AOT.
  
  ADDITIONAL KEYWORDS:
  IDAAV4R1/K IDAAV5R1/K
  INCORROUT SQLMERGE SQLCODE4742 RC22
  

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:

  UI46617 UI46618

Modules/Macros

• DSNXOMRG
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI46617

     UP17/05/06 P F705

• RB10 PSY UI46618

     UP17/05/06 P F705

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.