Forum Discussion
IBM DB2 - tables not loading
Hi ,
Problem Statement: I am using IBM DB2 as datasource in PBI desktop after giving server name and database name Navigator window is showing up in whihc I need to select the tables to load it into PBI but after selecting the table name it gives error
"Microsoft Db2 Client: SYSIBM.SQLSTATISTICS 00E7900C SQL STATE= 55023 SQLCODE = -471"
Also tried giving the query in SQL Statement window but still getting the same error with the difference
"Microsoft Db2 Client: SYSIBM.SQLCOLUMNS 00E7900C SQL STATE= 55023 SQLCODE = -471"
6 Replies
Based on my research, the issue is more related to IBM DB2. As per this article, error message 00E7900C means that SQL CALL statement or user-defined function invocation could not be processed. Please verify that the stored procedures for JDBC and ODBC support are enabled, and ensure the procedures are setup correctly with WLM.
You can contact IBM support to get more details about this issue.
Regards,
Lydia- Anonymous, As you said, I had discussion with DB2 people and they told whenever connection is made to pull data from DB2 it firstly invokes the system stored procedures like SYSIBM.SQLCOLUMNS and SYSIBM.SQLSTATISTICS. So they made changes in their end and when I try it was working fine. I have another question here, I am trying to pull tables from particular schema which contains more than 30,000 tables in it but when I make connection in PBI desktop it just shows 10,000 tables and not more than that. Is there any limitations in showing the list of available tables in PBI desktop. Regards, Gowrishankar
gowrishankar65,
Do you have sufficient permission on the other tables? Could you please write a specific SQL statement to get data from one of the 20000 tables during connection and check if it is successful?
Regards,
Lydia
