A fix is available
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 number
PM88071
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED UR1
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2013-04-29
Closed date
2013-08-23
Last modified date
2014-02-04
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 February 2014