I have two DB2 Servers. I connect using the following URL:
jdbc:db2://fbms2052:50000/nexustst
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.
Thanks.
James
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have two DB2 Servers. I connect using the following URL:
jdbc:db2://fbms2052:50000/nexustst
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.
Thanks.
James
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