A fix is available
APAR status
Closed as new function.
Error description
YYYYMMDD date format support on an accelerator. IDAAV5R1/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of DB2 11 for z/OS who use * * query acceleration and LOCAL DATE FORMAT of * * YYYYMMDD. * **************************************************************** * PROBLEM DESCRIPTION: Queries referencing an expression that * * returns a LOCAL DATE format of YYYYMMDD * * cannot be offloaded. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR provides support for locally-defined DATE format of YYYYMMDD for users of IBM DB2 Analytics Accelerator so that queries referencing an expression that return a DATE data type are eligible for query offload. The new DATE format to be allowed is YYYYMMDD. The new support for LOCAL DATE format is enabled using a new option, 7, to the DB2 subsystem parameter DSN6SPRM.QUERY_ACCEL_OPTIONS, which is used to specify additional types of SQL queries to be included in query offloading. The new option is: * 7 : Specifies that queries that reference an expression with a DATE data type that uses a LOCAL format are not blocked from running on an accelerator server. The accelerator server uses the format YYYYMMDD, padded with two blanks at the end, to interpret the input and output date value. Option 7 is not permitted when option 4 has been selected. Specify option 7 only when one of the following conditions exists: - The DATE FORMAT field of the DSNTIP4 panel specifies LOCAL. - Application programs that process SQL on DB2 are precompiled with the DATE(LOCAL) option. In both cases, the LOCAL date exit routine must define the specific YYYYMMDD date format. If the LOCAL format is not defined as YYYYMMDD, the query might return unpredictable results. See the HOLD information for additional details on this option. Additional Keywords: IDAAV4R1/K IDAAV5R1/K SQLDATE
Problem conclusion
Temporary fix
Comments
Code has been added to support locally-defined DATE format of the form YYYYMMDD when option 7 is specified for DSN6SPRM.QUERY_ACCEL_OPTIONS, and the DATE FORMAT field of install panel DSNTIP4 specifies LOCAL or when application programs that process SQL on DB2 have been precompiled with the DATE(LOCAL) option. In either case, the LOCAL date exit routine must also define the specific YYYYMMDD date format.
APAR Information
APAR number
PI55268
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2016-01-12
Closed date
2016-03-10
Last modified date
2016-04-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI36058
Modules/Macros
DSNDQWPZ DSNDSPRM DSNLXRSQ DSNTINST DSNTIP8A DSNWZIFB DSNXONZA DSNXONZB DSNXONZQ DSNXONZS DSN6SPRM
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI36058
UP16/03/25 P F603
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 April 2016