PI92837: SQLCODE -805 FOR SQL OPERATION ON ACCELERATOR ONLY TABLE (AOT) WHEN THE SQL AUTH ID ONLY HAS EXPLAIN PRIVILEGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• SQLCODE -805 received when attempting an SQL SELECT , INSERT ,
  UPDATE , DELETE , etc. on an Accelerator Only Table (AOT) when
  using DB2 query acceleration and the SQL authorization ID holds
  the DB2 EXPLAIN privilege but no other required table
  privileges. SQLCODE -551 should have been received instead when
  that SQL statement was executed after the successful prepare for
  DESCRIBE or EXPLAIN only -- only a DESCRIBE or EXPLAIN of the
  SQL statement is allowed when only the EXPLAIN privilege is held
  

Local fix

• Use a different SQL authorization ID that holds the appropriate
  table privilege(s) for the SQL operation on the Accelerator
  Only Table, or GRANT the current SQL auth ID the necessary table
  privileges to perform the SQL operation on the AOT.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 and 12 for z/OS users of                          *
  * Acceleration and have Explain-Only                           *
  * privilege.                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a user with Explain Only                                *
  * privilege tries to prepare then                              *
  * execute an Insert, Update or Delete                          *
  * statement on an Accelerator-Only                             *
  * table (AOT), instead of the expected                         *
  * SQLCODE -551 on execution, the user                          *
  * may get:                                                     *
  * SQLCODE -805 during Prepare; or                              *
  * SQLCODE -904 during Prepare; or                              *
  * ABEND0C4 at DSNXEDP + 6D22.                                  *
  * Other SQL errors or abends may occur.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Db2 takes incorrect path when a user that has Explain-Only
  privilege prepares an Insert, Update or Delete statement on
  an AOT. This causes Db2 to incorrectly build its internal
  control blocks.
  

Problem conclusion

• Db2 code is corrected for the described scenario.
  
  Additional Keywords: IDAAV4R1/K IDAAV5R1/K IDAAV7R1/K
                       ABEND0C4 SQLCODE805 SQLCODE904
  

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:

  UI54912 UI54913

Modules/Macros

• DSNXEDP
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI54912

     UP18/04/17 P F804

• RB10 PSY UI54913

     UP18/04/17 P F804

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.