PH28285: DB2 HINT FOR ' INSERT INTO AOT WITH SELECT FROM TABLE ' PERSISTSTO NEXT ACCELERATED STMT WITHIN SAME TRANSACTION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using QUERY ACCELERATION , a Db2 for z/OS serviceability
  HINT specified for an
    INSERT INTO 'Accelerator only table' SELECT FROM table-name
  persists to next accelerated statement in the same transaction
  when using a tool / application to submit your dynamic SQL, and
  the application reuses the same SQL PREPARE to submit multiple
  dynamic SQL statements without issuing a COMMIT between
  the PREPARE requests.
  IDAAV7R1/K IDAAV7R5/K
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and 12 for z/OS users who either                  *
  * use IBM Db2 Analytics Accelerator for z/OS                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Internal serviceability enhancement.                         *
  * There are no external changes                                *
  * implemented by this APAR.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Internal serviceability enhancement. There are no external
  changes implemented by this APAR.
  

Problem conclusion

• Internal serviceability enhancement. There are no external
  changes implemented by this APAR.
  IDAAV7R1/K IDAAV7R5/K
  

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:

  UI73252 UI73253

Modules/Macros

• DSNXERT2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI73253

     UP20/12/30 P F012

• RC10 PSY UI73252

     UP20/12/31 P F012

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.