A fix is available
APAR status
Closed as program error.
Error description
When using Db2 V11 for z/OS and IBM Db2 Analytics Accelerator V6 for Cloud ( dashdb ), accelerator Workload Balancing (WLB) does not occur for accelerated queries. . Additional search keywords: IDAAV6R1/K
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 V11 for z/OS users of IBM DB2 * * Analytics Accelerator V6 for Cloud and * * Accelerator Workload Balanacing ( WLB ) * **************************************************************** * PROBLEM DESCRIPTION: When accelerating queries where 2 or * * more IBM DB2 Analytics Accelerator * * V6 for Cloud accelerators * * (Db2 Warehouse on Cloud, formerly * * dashDB for Analytics) qualify to run * * the query, Db2 V11 for z/OS did not * * apply accelerator Workload Balancing * * (WLB) when choosing an accelerator * * target for the query. Instead, Db2 * * always chose the same V6 accelerator to * * run the query for each execution. * * * * The problem exists for both dynamic and * * static accelerated queries for * * Accelerator V6 for Cloud. * **************************************************************** * RECOMMENDATION: * **************************************************************** User requested Db2 acceleration for a query that qualified for 2 or more IBM Db2 Analytics Accelerator V6 for Cloud accelerators, and expected accelerator Workload Balancing (WLB). However, for each run of the accelerated query, Db2 V11 for z/OS always sent the query only to the same V6 Cloud accelerator, instead of alternating the target V6 Cloud accelerator based on accelerator workload balancing. . Db2 did not correctly recognize that multiple V6 Cloud accelerators qualified to run the accelerated query. . This specific accelerator WLB problem only occurs for IBM Db2 Analytics Accelerator V6 for Cloud accelerators (Db2 Warehouse on Cloud, formerly dashDB for Analytics).
Problem conclusion
DB2 code to support Accelerator Workload Balancing (WLB) for IBM Db2 Analytics Accelerator V6 for Cloud was corrected to to apply WLB for a query where multiple V6 for Cloud accelerators qualify to run the query. . Additional search keywords: IDAAV6R1/K IDAAV7R1/K
Temporary fix
AI84255
Comments
APAR Information
APAR number
PI84255
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-07-10
Closed date
2017-10-24
Last modified date
2017-12-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
010PC2 UI51387
Modules/Macros
DSNXONZA
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RB10 PSY UI51387
UP17/11/08 P F711
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 December 2017