DB2 9.1 Database Structure is empty.

jfrankman
2007-10-03
2013-04-29
  • jfrankman

    jfrankman - 2007-10-03

    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

     
    • jfrankman

      jfrankman - 2007-10-03

      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.

       
      • amr roushdi

        amr roushdi - 2007-10-04

        Hi James , this usually happens after the installtion of a fixpak

         

Log in to post a comment.