Forum Discussion

Urid1969's avatar
Urid1969
Helper I
9 years ago
Solved

Cannot connect to AS400 via IBM DB2 database

Hello friends Keep getting error while trying to connect to AS400 
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Urid1969,

    Firstly, please check the IBM AS400 server status and port status as per the below steps.

      a. Verify that if the IBM server is up and running following the troubleshoot steps in this article.
      b. Check the port status by using “netstat” in your IBM server and verify the port is in state Listen.

    Secondly, choose each driver in the following screenshot when connecting to IBM database and check if it is successful. When you choose IBM, please ensure that you have IBM DB2 Data Server Driver installed on your computer (minimum requirement is the IBM Data Server Driver Package (DS Driver)). Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).


    Thirdly, check if you are able to connect to IBM AS400 database from other application such as Excel.

    Thanks,
    Lydia Zhang

Nonsensely's avatar
Nonsensely
Advocate I
6 years ago

I ended up creating ODBC connections and connecting via ODBC to all of my iSeries files.  Not sure what the benefit is for having it either way, is the direct connection faster?

Jeick's avatar
Jeick
Frequent Visitor
6 years ago

Nonsensely 

My guess is that you want to know what is the best or recommended connection in Power BI for DB2 generally.

I know that ODBC connections can potentially be slow for sometimes for large database management systems and i have read that people complain about slow speed connecting to DB2 via ODBC in Power BI (Look at post  #2 in this thread).

 

I would recommend you using either the Microsoft or the IBM Driver instead. I had less struggle with using the this Microsoft Driver, so I am using this one. In terms of performance the Microsoft Driver seems to retrieve Data slightly slower. I tested an import with 3 Million Rows of Data from a large DB2 table. The Microsoft driver needed 2 Mins 50 Sec and the DB2 driver 2 Mins 25 Sec.