PH13956: QUERY ACCELERATION NOT WORKING WHEN ELIGIBLE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• ODA v1.2: Query acceleration not working when eligible
  Right now when going through a VT the SQL Engine by default sets
  "Current Query Acceleration" to "Enable with Failback" which
  allow Db2 to determine if it goes to Db2 native table or
  Accelerated table.
  This can be changed with the setting of OPTBNOQA which can be
  set in any VTB Rule.  Currently it is shipped in
  the ***MDTBL rule.
  *Currently:*
  OPTBNOQA = 0 sets Current Query Acceleration to "Enable with
  Failback"
  OPTBNOQA = 1 sets Current Query Acceleration to "None".
  We would like to make a change so that all functions of Current
  Query Acceleration are available to be set.
  *Example:*
  OPTBNOQA = 0 sets Current Query Acceleration to "Enable with
  Failback"
  OPTBNOQA = 1 sets Current Query Acceleration to "None".
  OPTBNOQA = 2 sets Current Query Acceleration to "Enable"
  OPTBNOQA = 3 sets Current Query Acceleration to "Eligible".
  OPTBNOQA = 4 sets Current Query Acceleration to "All"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: APPLY the PTF                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: Query acceleration not working when     *
  *                      eligible                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF                                *
  ****************************************************************
  Query acceleration not working when eligible
  

Problem conclusion

• APPLY the PTF
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• HLVBINJ  HLVCRDBD HLVMDTBL HLVOBRSQ HLVOTBEV HLVSQ29D HLVSQ29N
  HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD HLVSQ2CN HLVSQL9D
  HLVSQL9N HLVSQLAD HLVSQLAN HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI64181

     UP19/07/17 P F907  

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.