PH70079: SUBSYSTEM PARAMETER QUERY_ACCEL_OPTIONS BEHAVIOR FOR IDAA V8

APAR status

• Closed as new function.

Error description

• Subsystem parameter QUERY_ACCEL_OPTIONS behavior for IDAA V8
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users who use IBM Db2    *
  *                 Analytics Accelerator V7 or later.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The Db2 z/OS subsystem parameter        *
  *                      QUERY_ACCEL_OPTIONS option 8,10, and    *
  *                      11 is modified for offloading queries   *
  *                      to IBM Db2 Analytics Accelerator for    *
  *                      z/OS.                                   *
  ****************************************************************
  To help with the migrations and coexistence of IBM Db2
  Analytics Accelerator for z/OS(IDAA) version 7 and version 8
  accelerators, Db2 z/OS subsystem parameter QUERY_ACCEL_OPTIONS
  option 8,10, and 11 is modified as the following:
    Option 8 FAVOR NEW ACCELERATOR_TYPE:
      Remove the warning message: "Important: FAVOR NEW
            ACCELERATOR_TYPE is ignored if option 11, USE ONLY
            NEW ACCELERATOR_TYPE, is set to YES."
      Change NO explanation to: "Specifies that in a Db2
            environment that includes both a latest version
            accelerator server and an older version accelerator
            server, statements that are eligible to be
            accelerated on either of the accelerator servers are
            sent to the older version accelerator server."
      Change YES explanation to: "Specifies that in a Db2
            environment that includes both a latest version
            accelerator server and an older version accelerator
            server, statements that are eligible to be
            accelerated on either of the accelerator servers are
            sent to the latest version accelerator server."
    Option 10 BALANCE WORKLOAD BETWEEN VERSIONS:
      Remove the warning message: "Important: BALANCE WORKLOAD
            BETWEEN VERSIONS is ignored if option 11, USE ONLY
            NEW ACCELERATOR_TYPE, is set to YES."
    Option 11 USE ONLY NEW ACCELERATOR_TYPE:
      remove the warning message: "Important: When option 11 is
            set to YES, the following options, if specified, are
            ignored: 8: FAVOR NEW ACCELERATOR_TYPE 10: BALANCE
            WORKLOAD BETWEEN VERSIONS"
  
  For behavior involving IDAA V8 server, this Apar requires a
  future IDAA release.
  
  Additional Keywords:
    IDAAV7R1/K IDAAV7R5/K IDAAV8R1/K
  

Problem conclusion

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:

  UO07405

Modules/Macros

• DSNX8WAC
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels