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

Obtain the fix for this APAR.

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