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.
|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)"
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 "email@example.com" 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