PM88071: SUPPORT OFFLOAD OF IMPLICIT CAST FOR DECFLOAT, BIT OPERATIONS, AND TIMESTAMPDIFF

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support offload of implicit cast for DECFLOAT, bit operations,
  and TIMESTAMPDIFF.
  Also see APAR PI10239.
  IDAAV3R1/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 for z/OS who use         *
  *                 IBM DB2 Analytics Accelerator.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides the following new    *
  *                      functions for IBM DB2 Analytics         *
  *                      Accelerator:                            *
  *                                                              *
  *                      (1) Query prioritization support for    *
  *                          remote query offload to an          *
  *                          accelerator.                        *
  *                                                              *
  *                      (2) Enable execution of bit             *
  *                          manipulation functions on an        *
  *                          accelerator.                        *
  *                                                              *
  *                      (3) Enable execution of TIMESTAMPDIFF   *
  *                          on an accelerator.                  *
  *                                                              *
  *                      (4) Enable execution of queries that    *
  *                          involve implicit cast with the      *
  *                          DECFLOAT datatype.                  *
  *                                                              *
  *                      This APAR also fixes the following      *
  *                      problem for IBM DB2 Analytics           *
  *                      Accelerator:                            *
  *                      (5) SQLCODE -901 is incorrectly         *
  *                          issued for a query with the         *
  *                          TRUNC() scalar function.            *
  *                                                              *
  *                      (6) SQLCODE -904 is incorrectly         *
  *                          issued for a query with             *
  *                          outer joins and table expressions.  *
  *                                                              *
  *                      (7) EXPLAIN may not populate            *
  *                          DSN_QUERYINFO_TABLE with            *
  *                          REASON_CODE = 15 when CURRENT       *
  *                          QUERY ACCELERATION=ENABLE           *
  *                                                              *
  *                      (8) Storage leak occurs for an          *
  *                          INSERT with a common table          *
  *                          expression with row                 *
  *                          permissions.                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR provides the following new functions for IBM DB2
  Analytics Accelerator:
  
  (1) Query prioritization support for remote query offload to
      an accelerator.
  
  (2) Enable execution of bit manipulation functions BITAND,
      BITANDNOT, BITOR, BITXOR, and BITNOT on an accelerator.
      The expression, expression1 or expression2 value must be
      SMALLINT, INTEGER, or BIGINT for the function to execute
      on an accelerator.
  
  (3) Enable execution of TIMESTAMPDIFF
      on an accelerator. The result returned is the accurate
      value that considers leap years and the varying total
      number of days in a month.  This is different than DB2
      behavior, which does not account for leap years and
      calculates that all months have 30 days.
  
  (4) Enable execution of queries that involve implicit cast with
      the DECFLOAT datatype.  A query will not execute on an
      accelerator if a DECFLOAT column is referenced or if
      a column implicitly cast to DECFLOAT is part of the
      result set.
  
  This APAR also fixes the following problems for IBM DB2
  Analytics Accelerator:
  (5) SQLCODE -901 is incorrectly issued for a query with the
      TRUNC or TRUNCATE scalar function if numeric-expression-1
      or numeric-expression-2 is not a DECIMAL or FLOAT datatype.
      Code is fixed to offload this query to an accelerator.
  
  (6) SQLCODE -904 is incorrectly issued for a query that has
      both outer joins and table expressions.  Code is fixed
      to offload this query to an accelerator.
  
  (7) EXPLAIN may not populate DSN_QUERYINFO_TABLE with
      REASON_CODE = 15 when CURRENT QUERY ACCELERATION=ENABLE.
      Code is fixed to to populate DSN_QUERYINFO_TABLE correctly.
  
  (8) Storage leak occurs for an INSERT with a common table
      expression with row permissions.
  
  Additional Keywords:
  IDAAV3R1/K SQLCODE901 SQLCODE904 SQLTIMESTAMPDIFF SQLBITAND
  SQLOUTERJOIN SQLEXPLAIN SQLCTE SQLINSERT DB2STGLK/K
  SQLACCESSCONTROL SQLTRUNC
  

Problem conclusion

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK96992

Modules/Macros

• DSNLXGLM DSNLXRSQ DSNXOBFC DSNXOD5  DSNXOEX1 DSNXONZA DSNXONZC
  DSNXONZO DSNXONZQ DSNXONZS DSNXOOS1 DSNXORFN
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK96992

     UP13/09/13 P F309 ½

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.