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:
- Tables with CCSID 1379 cannot be loadedSummaryStored 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 workaroundNot available.
- Duplicate rows in accelerator-shadow tablesSummaryWhen 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 workaroundWhen 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.
- Queries that extract values from string representations of DATE or TIMESTAMP values failSummaryThe 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 workaroundExplicitly 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"}}]
Was this topic helpful?
Document Information
Modified date:
08 August 2018
UID
swg27050097