Forum Discussion

Post Patron

9 years ago

DB2 error: SQL0204N...is an undefined name

I'm trying to connect to an IBM DB2 database on z/OS using the IBM driver (the Microsoft driver requires a package collection to be specified whose value I am unaware of). If I select "Navigate using...

Need Help

Anonymous

Not applicable

9 years ago

Hi robarivas，

I am able to connect to IBM db2 database in the latest version of Power BI Desktop using both IBM driver and Microsoft Driver.

In your scenario, do you encrypt the connection between IBM and client using SSL? If so, ensure that you have configured these settings described in this article. In addition, are you able to connect to your IBM DB2 database from IBM data studio? Please make sure that IBM data studio is installed in the same machine as Power BI Desktop.

Thanks,
Lydia Zhang

robarivas

Post Patron

9 years ago

Hello Anonymous. Thank you for your response. Are you confirming that you've successfully connected to a DB2 database on z/OS specifically? One of my concerns is that the Power BI DB2 connector might be for a different "flavor" of DB2 (like "LUW").

I do not know if I encrypt the connection. If I do it is not intentional. Is there a way I can configure something so as to prevent SSL encryption?

I did try Data Studio and it did connect to the database sucessfully. However, it did nothing as far as I could tell to help with my Power BI connectivity issue.