Forum Discussion
Post PatronIBM DB2 Connection
I recently had to help a group of clients connect, and we found that the following conditions were necessary:
1) You must have the DB2 client installed on the machine from which you are trying to connect
2) Under Advanced Options in the Power BI connection dialog:
a) You have to use the Microsoft driver (as you mention)
b) You have to uncheck the "Navigate Using Full Hierarchy" option
3) You need to connect using the Database tab (not the Windows tab) and use your MF credentials
Without all of these in place, we had to use ODBC to connect.
FWIW, the view provided form the MF was basically just a selection of tables -- no individual columns were selectable.
Hi robarivas,
Do you specify specific SQL statements when connecting to IBM DB2 database? Based on my research, the above error could occur when an application is running out of resources, which is possibly due to not closing connections or improper statements. I would recommend troubleshoot the above issue following the instructions in this article and communicate to DBA to check your SQL statements .
In addition, please go to File -> Options and settings -> Options -> Diagnostics and click "enable tracing", then connect to IBM DB2 and check the detailed logs in the traces folder. Also please help to post the detailed logs here.
Thanks,
Lydia Zhang
robarivasThank you for the response Anonymous. I do not specify any specific SQL statements when trying to connect to the IBM DB2 database. And I do not understand the content of the article you referred me to.
Interestingly, the connection over ODBC does actually work but performance is unusuably slow (such as when I filter a column for example).
I've emailed the log files to [email protected]
I am an administrator for DB2 on Z/OS trying to support a Power BI desk-top user having the same problem. The user sees a -805 error returned to his session, however, this error is not taking place on Z/OS. The connection was never made. I believe the package that needs to be bound is for the data provider to support the connect request. At this time we are stuck because we don't konw what package to bind.
I'm getting the same problem. It works on one DB2 System which has the Package MSCS001 Bound. Can I download MSCS001 from Microsoft somewhere and Bind MSCS001 on the system I need Power BI access to?
