DB2 IDAA

[JohannesSpronk]

Please, does anybody know, whether and how you can enable the IBM DB2 Accelerator (IDAA) in the Advanced Editor of Power Query? I have the following:
let
Source = DB2.Database("Server", "Database", [HierarchicalNavigation=true, Implementation="Microsoft"]), Query="SET CURRENT QUERY ACCELERATION=ELIGIBLE",
XXXXX = Source{[Schema="xxxxxx"]}[Data],
XXXXX = XXXXXX{[Name="DB2Table"]}[Data]

There is no syntax error and I do get the data loaded into Power BI Desktop from the On Premises DB2 table. But I do not know if it Query="SET CURRENT QUERY ACCELERATION=ELIGIBLE" is actually doing something. How do I know? 

Should I see some kind of code in the native Query? 

Thanks for your replies!

[bharatn08]

I am looking for a feasibilty test to check if we can connect to the DB2 IDAA via Power BI, by looking at the question I do understand that we can connect to it but just for confirmation - we can connect to db2 IDAA enables via power just like the normal db2 connect and then in query mention that this should be processed via IDAA (which is the actual question of this post). This understading is correct?

Apologies in advance for the dumb question.

[JohannesSpronk · Accepted solution]

Our solution is to change the syntax in Power Query using Advanced Editor

= DB2.Database("server", "database", [HierarchicalNavigation=true, Implementation="Microsoft", Query="SET CURRENT QUERY ACCELERATION=ENABLE; SELECT * FROM database.table FOR READ ONLY;"])

[Syndicate_Admin]

Hi, you can use SET CURRENT QUERY ACCELERATION=ALL to force the use of  IDAA. The query will fail if no IDAA accelerator  is available. 

[v-jingzhang]

Hi @JohannesSpronk 

I don't have experience in IBM DB2 but I think it should have its own performance monitor tools like SQL Server Profiler for SQL Server Databases. You can create two queries in Power BI Desktop, one has the statement "SET CURRENT QUERY ACCELERATION=ELIGIBLE" while the other doesn't. Open the performance monitor tool and start monitor traces. Then click "Refresh" in Power BI Desktop to reimport data into Power BI. Every table will send a query to the database. After refresh finishes, you can stop the tracing and compare the query time of two queries. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[JohannesSpronk]

Thank you for taking the time and replying with an advise!