PH29627: DB2 12 FOR Z/OS NEW FUNCTION TO SUPPORT NEW FUNCTION IN IBM DB2 ANALYTICS ACCELERATOR V7

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Db2 12 for z/OS new function to support new function in IBM
  Db2 Analytics Accelerator V7.
  IDAAV7R1/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 12 for z/OS users who use IBM Db2                    *
  * Analytics Accelerator V7.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This apar is to support the                                  *
  * Compatibility Mode of IBM Db2                                *
  * Analytics Accelerator V7. With this                          *
  * feature, when a V7 accelerator is in                         *
  * compatibility mode, it will function                         *
  * like a V5 accelerator. All the new                           *
  * features developed for V7 will be                            *
  * disabled.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Generally an IBM Db2 Analytics Acelerator's V7 Accelerator
  supports more functions and features than a V5 Accelerator.
  The compatibility mode of the V7 Accelerator only
  supports what V5 supports. I.e. a V7 accelerator in
  compatiblity mode only supports the same functions and features
  as a V5 accelerator. For example, when the V7 accelerator is
  in compatibility mode, binary and decfloat data types,
  recursive CTE etc. will not be supported. Thus when the
  customer tries to offload a query with binary and decfloat data
  types, recursive CTE etc. to a V7 accelerator in the
  compatibility mode, the same error code will be expected as if
  the query is sent to a V5 Accelerator.
  Contact IBM Customer Service if you want to use this feature.
  Additional Search Keywords:
  IDAAV5R1/K IDAAV7R1/K IDAAV7R5/K
  

Problem conclusion

Temporary fix

Comments

• With PH29627, the compatibility mode of the IBM Db2 Analytics
  Accelerators's V7 Accelerator is successfully supported. When
  a V7 Accelerator is in compatiblity mode, it will only
  support the same functions and features as if it's a V5
  Accelerator.
  

APAR Information

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

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

  UI73356

Modules/Macros

• DSN6SPRM DSNXODML DSNXONZO DSNXOEX1 DSNXOIN  DSNDQWPZ DSNWZIFC
  DSNDSPRM DSNXOVD  DSNXOOS1
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI73356

     UP21/01/14 P F101

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.