PI72168: LIMITED SUPPORT FOR GRAPHIC AND VARGRAPHIC CAST SPECIFICATION AND BUILT-IN FUNCTIONS WITH DB2 QUERY ACCELERATION

APAR status

• Closed as new function.

Error description

• This apar introduces limited support for GRAPHIC and VARGRAPHIC
  CAST specifications and Built-in functions for use with
  DB2 accelerated queries.  These features are currently supported
  for queries run only in DB2, and this apar now extends limited
  support for these features with accelerated queries.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 11 for z/OS users of QUERY           *
  *                 ACCELERATION, CAST specifications CAST       *
  *                 AS GRAPHIC and CAST AS VARGRAPHIC, and       *
  *                 built-in functions GRAPHIC and VARGRAPHIC    *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR adds new limited support      *
  *                      for accelerating queries which use      *
  *                      the following:                          *
  *                       o CAST AS VARGRAPHIC                   *
  *                       o CAST AS GRAPHIC                      *
  *                       o GRAPHIC built-in function (BIF)      *
  *                       o VARGRAPHIC built-in funtion          *
  *                      These features are currently supported  *
  *                      for queries run only in DB2, and this   *
  *                      APAR now extends limited support of     *
  *                      these features to accelerated queries.  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  This APAR adds support for accelerating queries which
  use the following:
   o CAST AS GRAPHIC/VARGRAPHIC
   o VARGRAPHIC/GRAPHIC built-in function (BIF) without CODEUNITS
   o VARGRAPHIC/GRAPHIC BIF for UNICODE tables
   o INSERT INTO ... from SELECT FROM accelerated-table or
     accelerator-only-table (AOT), where the SELECT specifies--
     - CAST AS VARGRAPHIC/GRAPHIC for UNICODE tables
     - BIFs VARGRAPHIC/GRAPHIC for UNICODE tables
     Note that INSERT from SELECT may result in unexpected length
     from the CAST (specifically, extra padding with blanks)
     when the column being inserted into is larger than the cast
     result length and the data is mixed or double-byte
     characters.
  

Problem conclusion

Temporary fix

Comments

• DB2 V11 for z/OS has been modified to add limited support
  for CAST AS GRAPHIC/VARGRAPHIC and built-in functions
  GRAPHIC/VARGRAPHIC used in accelerated queries as described
  above.
  
  Additional search keywords: IDAAV4R1/K IDAAV5R1/K SQLFUNCTION
  

APAR Information

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

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

  UI44589

Modules/Macros

• DSNXOEX1 DSNXONZC DSNXONZQ DSNXONZS DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY

     UP