PI14368: MULTIPLE FIXES ON DB2 FOR Z/OS RUNNING WITH AN ACCELERATOR

A fix is available

Subscribe

APAR status

Closed as program error.

Error description

Multiple fixes on DB2 for z/OS running with an accelerator.
(d172099)
IDAAV4R1/K

Local fix

n/a

Problem summary

****************************************************************
* USERS AFFECTED: All users of DB2 for z/OS who use *
* IBM DB2 Analytics Accelerator. *
****************************************************************
* PROBLEM DESCRIPTION: This APAR fixes the following issues *
* for IBM DB2 Analytics Accelerator. *
* *
* (1) For an EXPLAIN of an INSERT with *
* subSELECT statement, *
* DSN_QUERYINFO_TABLE may not *
* populate with any rows. *
* (2) A query with the function TRUNC *
* may return incorrect output when *
* executed on an accelerator. *
* (3) A query that contains an ORDER BY *
* in a set operation may fail on *
* an accelerator. *
* (4) A query with the function CHAR *
* with a FOR BIT DATA column and *
* OCTETS may return incorrect *
* output. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
This APAR fixes the following issues for IBM DB2 Analytics
Accelerator.
(1) For an EXPLAIN of an INSERT with subSELECT statement,
DSN_QUERYINFO_TABLE may not populate with any rows when
zparm QUERY_ACCEL_OPTIONS does not include the value 2.
(2) A query with the function TRUNC may return incorrect
output when executed on an accelerator if the value of the
1st argument is very large. For example TRUNC(C1,-1) where
C1 is a BIGINT column with a value of 14683479057743532.
(3) A query that contains an ORDER BY within a set operation
UNION, UNION ALL, INTERSECT, INTERSECT ALL, EXCEPT, or
EXCEPT ALL may fail with SQLCODE -901 Reason "42000: ERROR:
found "NULLS" on an accelerator.
(4) A query with the function CHAR with a FOR BIT DATA
column and OCTETS may return incorrect output.
For static SQL queries that have been bound for acceleration
and will use any of the new functions above, after applying
this PTF, REBIND the package for the failing query.
Keywords:
IDAAV3R1/K IDAAV4R1/K SQLINCORR SQLINCORROUT INCORROUT
DB2INCORR/K SQLTRUNC SQLEXPLAIN SQLSETOP
SQLCHAR FORBITDATA