A fix is available
APAR status
Closed as program error.
Error description
VARCHAR_FORMAT AGAINST CHAR/VARCHAR COLUMN ON IDAA RETURN SQLCODE -901
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for z/OS users of IBM DB2 Analytics * * Accelerator V4 or V5 for DB2 QUERY * * ACCELERATION and the DB2 built-in function * * VARCHAR_FORMAT where the first argument of * * the BIF is a character data type. * **************************************************************** * PROBLEM DESCRIPTION: An accelerated query using the built-in * * function VARCHAR_FORMAT may incorrectly * * result in SQLCODE -901 from the * * Accelerator when the first argument of * * the BIF references a character column. * **************************************************************** * RECOMMENDATION: * **************************************************************** An accelerated DB2 query containing the built-in function VARCHAR_FORMAT may incorrectly result in SQLCODE -901 or SQLCODE -904 from the Accelerator when the first argument of the BIF references a CHAR, VARCHAR, GRAPHIC, or VARGRAPHIC column. . The IBM DB2 Analytics Accelerator Version 4 or Version 5 does not support these data/column types for the first argument of BIF VARCHAR_FORMAT, and that is why the query failed on the Accelerator with SQLCODE -901 (or -904). Instead, DB2 should not send such a query to the Accelerator but either run it only in DB2, or if the query should only be accelerated and not run in DB2, DB2 must fail the query with SQLCODE -4742 and Reason = 19, which means that the Accelerator is 'down-level' and does not support this query. Reason=19 is used because this problem does not occur with the IBM DB2 Analytics Accelerator Version 6, which supports this VARCHAR_FORMAT argument type usage. So the query with this specific VARCHAR_FORMAT can be accelerated to Accelerator V6. . This problem does not occur for the built-in function VARCHAR_FORMAT if the first argument does not use a CHAR, VARCHAR, GRAPHIC,or VARGRAPHIC column, and those queries are successfully accelerated.
Problem conclusion
DB2 has been modified so that a query using the built-in function VARCHAR_FORMAT with the first argument as a CHAR, VARCHAR, GRAPHIC, or VARGRAPHIC column, is not accelerated to IBM DB2 Analytics Accelerator V4 or V5. DB2 will either run this query only in DB2, or if the query should only be accelerated and not run in DB2, DB2 will fail the query with SQLCODE -4742 and Reason = 19, which means that the Accelerator is 'down-level' and does not support this query. ADDITIONAL KEYWORDS: IDAAV4R1/K IDAAV5R1/K INCORROUT SQLCODE901 SQLCODE904 SQLCODE4742
Temporary fix
Comments
APAR Information
APAR number
PI77849
Reported component name
IDAA FOR ZOS
Reported component ID
5697AQT00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-03-08
Closed date
2017-06-01
Last modified date
2017-07-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI47717
Modules/Macros
DSNXOD5 DSNXONZA DSNXORFN
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI47717
UP17/06/17 P F706
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":"11.0","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":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
05 July 2017