PI40068: SQLCODE4742 RC3 IF USER THAT HAS ONLY EXPLAIN AUTHORIZATION TRY TO ACCELERATE AN QUERY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• sqlcode4742 rc3 if user that has only explain authorization try
  to accelerate an query:
  
  Using user1:
  
  CREATE TABLE TBL ( COL01 CHAR (10) )
  ;
  GRANT EXPLAIN TO user2
  ;
  -> Add Table
  -> LOAD Table
  -> Enable for Acceleration
  
  Using user2:
  
  SET CURRENT QUERY ACCELERATION ALL
  ;
  SELECT * FROM SYSADM.TBRALF01 WITH UR
  ;
  return sqlcode4742 rc3:
  
  DSNT408I SQLCODE = -4742, ERROR:  THE STATEMENT CANNOT BE
  EXECUTED BY DB2 OR IN THE ACCELERATOR (REASON 3)
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 and DB2 11 for z/OS      *
  *                 who use query acceleration.                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: An SQLCODE -4742 reason code 3 is       *
  *                      incorrectly issued for query            *
  *                      acceleration when the user only has     *
  *                      the EXPLAIN privilege or BIND/REBIND    *
  *                      with EXPLAIN(ONLY) is used.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An SQLCODE -4742 reason code 3 is incorrectly issued for query
  acceleration when the user only has the EXPLAIN privilege or
  BIND/REBIND with EXPLAIN(ONLY) is used and
  QUERY ACCELERATION is ALL.
  
  Keywords:
  IDAAV4R1/K SQLEXPLAIN SQLCODE4742
  

Problem conclusion

• Code is fixed so that SQLCODE -4742 reason code 3 is no longer
  issued incorrectly.
  Only SQLCODE 4726 should be issued when the user has EXPLAIN
  privilege or BIND/REBIND with EXPLAIN(ONLY) is used and
  QUERY ACCELERATION is ALL.
  

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:

  UI29045 UI29046

Modules/Macros

• DSNXONZO
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI29045

     UP15/07/17 P F507

• RB10 PSY UI29046

     UP15/07/17 P F507

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.