IBM Support

PI54842: SQLCODE4742N RSN901 FOR RUNNING QUERY ON ACCELERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQLCODE4742N RSN901 RC901 for running query on accelerator
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use            *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR removes a restriction that    *
    *                      blocks execution of an SQL statement on *
    *                      an accelerator that contains:           *
    *                      (1) A correlated subquery.              *
    *                      (2) The correlated subquery selects     *
    *                      an aggregate function and IFNULL,       *
    *                      COALESCE, VALUE, DECODE, or CASE        *
    *                      expression is on the aggregate          *
    *                      function.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR removes a restriction that blocks execution of an SQL
    statement on an accelerator that contains:
    (1) A correlated subquery.
    (2) The correlated subquery selects an aggregate function and
    IFNULL, COALESCE, VALUE, DECODE, or CASE expression is on the
    aggregate function.
    
    Example:
    SELECT * FROM T2 AS A
    WHERE C0=( SELECT CASE WHEN MAX(C0) IS NULL THEN 1 ELSE
    MAX(C0) END
               FROM T2 AS B
               WHERE A.C0=B.C0 AND 1=2);
    
    Prior to this APAR, execution of the statement with QUERY
    ACCELERATION=ALL would issue SQLCODE -4742 reason code 901.
    
    Keywords:
    IDAAV4R1/K IDAAV5R1/K SQLCODE4742
    

Problem conclusion

  • DB2 code is changed so that SQL statements as described above
    can execute successfully on an accelerator.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI54842

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-01-05

  • Closed date

    2016-02-04

  • Last modified date

    2016-03-02

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI35078 UI35079

Modules/Macros

  •    DSNXOD5  DSNXONZA DSNXONZB DSNXONZO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI35078

       UP16/02/19 P F602

  • RB10 PSY UI35079

       UP16/02/19 P F602

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 #: PI54842

Modified date: 02 March 2016


Translate this page: