IBM Support

PI55268: YYYYMMDD DATE FORMAT SUPPORT ON AN ACCELERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

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.



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI55268

Modified date: 05 April 2016


Translate this page: