I have two DB2 Servers. I connect using the following URL:
Driver class name is: com.ibm.db2.jcc.DB2Driver
If I log into server A the database shows up in the Database Structure view, but when I click the "+" to check for all the schemas, nothing is there. If I do the same for server B using the same connection everything works fine.
At first I thought this could be an authority issue, but as far as I can tell the authorities for the user are identical in each server.
What can I do to get Server A to display all the schemas in the Database Structure view.
To answer my question,
1. I first opened the PDE Runtime Error log view in Eclipse. Window->Show view ->PDE Runtime->Error Long
2. The under a message title "Error loading children" the error log displayed the following:
"com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805"
3. From IBM's website (http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/au16620_.htm) I found that to fix this problem you had to do the following using the db2 command line on server you are trying to connect to.
db2 => connect to database-name
db2 => bind path\db2schema.bnd blocking all grant public sqlerror continue
Once I did that the schema came up fine.
Hi James , this usually happens after the installtion of a fixpak
Log in to post a comment.