IBM Support

Known issues for support of DB2 12 for z/OS with IBM DB2 Analytics Accelerator for z/OS V 5.1.0

Product Documentation


Abstract

This document describes known issues for support of DB2 12 for z/OS with IBM DB2 Analytics Accelerator for z/OS Version 5.1.0

Content

DB2 12 for z/OS is supported by IBM DB2 Analytics Accelerator for z/OS Version 5.1.0 using maintenance level PTF-2 or higher.
The following issues are known:

  1. Tables with CCSID 1379 cannot be loaded
    Summary
    Stored Procedure ACCEL_LOAD_TABLES fails with error AQT10050E - An internal error occurred on the [...] accelerator [...] ICU converter could not be created for CCSID 1379.
    Solution or workaround
    Not available.
  2. Duplicate rows in accelerator-shadow tables
    Summary
    When a new partition is inserted into the middle of a table, the product's load recommendations might prove unsuitable. This can lead to duplicate rows in accelerator-shadow tables.
    Solution or workaround
    When inserting a new partition into the middle of a table, reload the new partition and the modified partition. If you are uncertain, reload the entire table.
  3. Queries that extract values from string representations of DATE or TIMESTAMP values fail
    Summary
    The following functions might return an error when an argument to a function is a string representation of a DATE or TIMESTAMP value
    • DAYOFWEEK
    • DAYOFYEAR
    • WEEK_ISO
    • MONTH
    • YEAR
    • EXTRACT
    Solution or workaround
    Explicitly cast string representations of DATE or TIMESTAMP values to "real" DATE or TIMESTAMP values (data type DATE or TIMESTAMP) before you extract values.

[{"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
08 August 2018

UID

swg27050097