2 Replies Latest reply on May 21, 2007 6:17 PM by ST91402

    DB2 Issues

      I cannot seem to complete the DB2 installation instructions.  DB2 is installed and working.  I have created a DB, I can connect to the DB and then following the instructions in the install guide, I select query and attempt to enter the two commands in step 2 which fail.

       

      My environment is Windows Server 2003, Sunglass (sun distro) and DB2.  Java and Sunglass are both installed and working.  I have imported the clearspace war file into sunglass and I am able to launch the clearspace admin app.

       

      Thanks!

       

      Here are the error messages:


      Commands Entered


      connect to WIKI ;


      connect to WIKI

       

         Database Connection Information

       

      Database server        = DB2/NT 9.1.2

      SQL authorization ID   = ADMINIST...

      Local database alias   = WIKI

       

       

      A JDBC connection to the target has succeeded.

       


      Commands Entered


      CREATE DB WIKI ALIAS WIKI;


      CREATE DB WIKI ALIAS WIKI

      SQL1047N  The application is already connected to another database.

       

      SQL1047N  The application is already connected to another database.

       

      Explanation:

       

      An application cannot create a database while connected to

      another database. 

       

      Binding a bind file to one database while already connected to

      another database is not permitted. 

       

      The command cannot be processed. 

       

      User Response:

       

      Disconnect from the active database and resubmit the command. 

       

      AND tyring a different name for the db:

       


      Commands Entered


      CREATE DB CLEAR ALIAS CLSP ;


      CREATE DB CLEAR ALIAS CLSP

      SQL1047N  The application is already connected to another database.

       

      SQL1047N  The application is already connected to another database.

       

      Explanation:

       

      An application cannot create a database while connected to

      another database. 

       

      Binding a bind file to one database while already connected to

      another database is not permitted. 

       

      The command cannot be processed. 

       

      User Response:

       

      Disconnect from the active database and resubmit the command.

        • Re: DB2 Issues

          hi st91402,

           

          You only need to run the commands mentioned in the documentation (ie:

           

          DB2 CREATE DB ALIAS

          DB2 CONNECT TO jive USER USING

          )

           

          if you haven't created the database, which it sounds like you already have. I'd skip that step and just go through the process of importing the schema:

           

          db2 \-tvf jive_clearspace_db2.sql

           

          where jive_clearspace_db2.sql is the path to the db2 installation script we provide.

           

          Cheers,

           

          AJ

          • Re: DB2 Issues

            Ok, that did it.  You may wish to clarify this in the install guide.  i.e. if you create the DB in the DB2 GUI the command lines indicated in step 2 of the install guide are not required.

             

            Also, the command to import the schema listed in the install guide did not work.  I had to remove the "\" in the command listed.

             

            db2 \-tvf jive_clearspace_db2.sql

             

             

            changed to:

             

            db2 -tvf c:\path\jive_clearspace_db2.sql

             

            Thanks, I am up and running.