IBM Data and AI

Welcome to the IBM Data and AI Ideas Portal for Clients!

We welcome and appreciate your feedback on IBM Data and AI Products to help make them even better than they are today!
Before you submit an idea, please perform a search first as a similar idea may have already been reported in the portal. If a related idea is not yet listed, please create a new idea and include with it a description which includes expected behavior as well as why having this feature would improve the service and how it would address your use case.
IBM Employees:
Clients:
  • Our team welcomes any feedback and suggestions you have for improving our offerings / products! This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.

  • If you have not registered on this portal please click on the following link and register. To complete registration you will need to open the email you will receive from Aha to confirm your identity. http://ibm.biz/IBM-Data-and-AI-Portal-Register

Additional Information:
  • The shorter URL for this site is: https://ibm.biz/IBM-Data-and-AI-Ideas

  • To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

  • Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

  • Please do not use the Ideas Portal for reporting bugs - we ask that you report bugs or issues with the product by contacting IBM support.

force the execution of a query on an accelerator if more than one is available.

The CURRENT ACCELERATOR special register specifies a preferred target accelerator or accelerators to which Db2 sends dynamic SQL queries.
But If you have multiple accelerators on which the same set of Db2 tables are accelerated, by default the workload balancing algorithm (WLB) distributes the queries based on the queue length on each accelerator. When the CURRENT ACCELERATOR special register names a particular eligible accelerator server, Db2 considers sending eligible SQL to that server before it sends it to other accelerator servers. But If the accelerator server that is named by the CURRENT ACCELERATOR isn't available, Db2 considers other available accelerator servers.

MY REQUEST: Create  new special register, for sample: CURRENT FORCE ACCELERATOR, that forces the execution on a chosen accelerator. And If the accelerator server that is named by the CURRENT FORCE ACCELERATOR  isn't available then the query run on DB2 or fail if CURRENT QUERY ACCELERATION is set to ALL.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Feb 3 2020
  • Will not implement
Who would benefit from this IDEA? I can have the same table on 2 accelerators but with diferent data. Then I can force the offload of my query to the accelerator with data that is my purpose or my test.
How should it work?

The table TAB1 is set available to acceleration on accelerator  IDAA1

The table TAB1 is set disable to acceleration on accelerator IDAA2.

I set CURRENT QUERY ACCELERATION  = ALL

I set CURRENT FORCE ACCELERATOR = IDAA2

 

If I running query SELECT * FROM TAB1 then fail with error "-4742, ERROR:  THE STATEMENT CANNOT BE EXECUTED BY DB2 OR IN THE ACCELERATOR (REASON 12)"

Customer Name RENFE
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    8 Apr 09:25am

    Hi Dennis,

    Thanks you for your review of my idea.
    Thanks for your time and your help.

    Regards.

  • Admin
    Dennis Lukas Mayer commented
    8 Apr 08:21am

    It is currently not planned to add a new special register to force a query to an Accelerator but this workaround might help:

    CREATE TABLE ACCELERATORS.ACC1 (C1 INT);

    INSERT INTO TABLE ACCELERATORS.ACC1(C1) values 1;

    add ACCELERATORS.ACC1 to ACCEL1

    load ACCELERATORS.ACC1 on ACCEL1

    SET CURRENT QUERY ACCELERATION = ALL

    SELECT <your query> FROM <yourtable>, ACCELERATORS.ACC1 for fetch only

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions