PI59522: ACCELERATOR OFFLOADING ERROR FOR QUERIES REFERENCING A VIEW WHICH SPECIFIES DATE CONSTANTS FORMAT (E.G. ISO, JIS, ETC.)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Accelerator offloading error for queries referencing a View
  which specifies date constants format (e.g. ISO, JIS, etc.)
  

Local fix

• NO WORK AROUND
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 and DB2 11 for z/OS who  *
  *                 use query acceleration and reference a view  *
  *                 with a DATE/TIME CONSTANT FORMAT (ISO, JIS,  *
  *                 etc.) in the view definition.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a DATE/TIME CONSTANT FORMAT        *
  *                      (ISO, JIS, etc.) is exploited in a view *
  *                      and the view is referenced in a query   *
  *                      to be offloaded to an accelerator,      *
  *                      incorrect output or other accelerator   *
  *                      errors might occur due to an improperly *
  *                      converted query sent to the             *
  *                      accelerator.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a view is defined with a DATE/TIME CONSTANT FORMAT (ISO,
  JIS etc.) and the view is referenced by a query to be offloaded,
  incorrect output or other accelerator errors might occur due to
  an improperly converted query sent to the accelerator.
  For example: CREATE VIEW V1(C1) AS
               SELECT CHAR(T1.DateCol, ISO)
               FROM T1;
  
               SET CURRENT QUERY ACCELERATION = ALL;
               SELECT * FROM V1 FOR FETCH ONLY;
  
  Keywords:
  IDAAV4R1/K IDAAV5R1/K SQLVIEW SQLDATE SQLTIME
  

Problem conclusion

• This APAR fixes a query conversion problem when the query is
  offloaded to an accelerator. The failing offloaded query
  references a view with a DATA/TIME CONSTANT FORMAT
  (ISO,JIS,etc.).
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI37465 UI37507

Modules/Macros

• DSNXONZQ DSNXONZS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI37465

     UP16/05/18 P F605 Ž

• RB10 PSY UI37507

     UP16/05/18 P F605 Ž

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.