IBM Support

PI49378: WHEN USING DB2 CROSSLOADER WITH SET CURRENT QUERY ACCELERATION, THE SPECIAL REGISTER IS NOT APPLIED TO THE QUERIES THAT ARE RUN

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When using DB2 Crossloader in batch-mode, the user issued
    EXEC SQL
          SET CURRENT QUERY ACCELERATION = ELIGIBLE;
        ENDEXEC
     before running a query (also using Crossloader) in order to
     accelerate that query to an accelerator. The query was indeed
     eligible for acceleration.
    
     However, the query was not accelerated, showing that
     the special register CURRENT QUERY ACCELERATION
     value specified was not applied to the query.
     The query should have been accelerated as requested by
     the SET CURRENT QUERY ACCELERATION statement.
    
      Additional search keywords: IDAAV3R1/K IDAAV4R1/K
    

Local fix

  • None, unless specifying DB2 zparm DSNZPARM
    QUERY_ACCELERATION = ELIGIBLE can be used for this entire
    DB2 subsytem.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS utility users of LOAD    *
    *                 INCURSOR and special register CURRENT QUERY  *
    *                 ACCELERATION                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: LOAD INCURSOR does not honor the        *
    *                      special register CURRENT QUERY          *
    *                      ACCELERATION                            *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    A LOAD INCURSOR utility was attempted following:
    
      EXEC SQL
         SET CURRENT QUERY ACCELERATION = ELIGIBLE
      ENDEXEC
    
      LOAD SQL DECLARE cursorname CURSOR FOR
         SELECT * FROM creator.tablename
      ENDEXEC
    
    LOAD INCURSOR did not honor the special register CURRENT QUERY
    ACCELERATION thus the query was not accelerated.  LOAD INCURSOR
    should honor that special register value.
    
    Additional keywords: IDAAV3R1/K IDAAV4R1/K
    

Problem conclusion

  • Code has been changed to now honor special register QUERY
    ACCELERATION for LOAD INCURSOR.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI49378

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-09-26

  • Closed date

    2015-10-16

  • Last modified date

    2015-12-02

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

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

    UI32121

Modules/Macros

  •    DSNUGUCA
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI32121

       UP15/11/03 P F511

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: B10

Reference #: PI49378

Modified date: 02 December 2015


Translate this page: