IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PI40068

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-04-30

  • Closed date

    2015-07-02

  • Last modified date

    2015-08-03

  • 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.



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PI40068

Modified date: 03 August 2015


Translate this page: