Topic
10 replies Latest Post - ‏2013-02-04T20:54:08Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

‏2013-01-30T19:07:08Z |
Hullo, I am new to IBM DB2 Express C. I installed the latest (10.2.1) 32-bit version on my Windows Enterprise 64 bit operating system. When I installed DB2 Express I chose Local System Account since our company disables creation on new accounts on local machines. I do have a Windows Administrator account however.

The reason I chose 32-bit is because I want to integrate a DB2 Express C DB in my 32 bit Visual C++ application using OLEDB. Since my application is still 32-bit, I thought it would be prudent to install 32 bit version only. I also installed the 32 bit version of the Data Studio.

I then created the sample database and it created it fine. I was able to connect to this database using my local windows account ID and PW. However, when I try to create a new database in DS using the same credentials it does not connect to the DB2 instance. It does not even connect. Any help would be gratefully appreciated.

Thanks,
Murali
Updated on 2013-02-04T20:54:08Z at 2013-02-04T20:54:08Z by SystemAdmin
  • loicjulien
    loicjulien
    96 Posts
    ACCEPTED ANSWER

    Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

    ‏2013-01-31T19:14:31Z  in response to SystemAdmin
    Hi Murali,

    I can start by providing a few tips, and if this does not resolve it, we may take it offline and post back to the forum.

    In my experience, such issues come from a mismatch 32/64 bits. Though, in your environment, it seems that you have already, very thoughtfully, made sure to anticipate such configuration problems.

    My assumptions:
    1- You are running the latest version of Data Studio. Data Studio 3.2
    2- DAS, on the server side, is started: db2admin start

    I propose to first validate:
    1/ Run db2level in the CLP to make sure it is indeed the 32 bits version.
    2/ In your Windows menu, under IBM Installation Manager -> "View installed packages", review the Package Group Architecture for Data Studio 3.2. Again, based on your description, should be 32 bits

    Let me know if this helps,
    ~Loic (lj@us.ibm.com)
    • SystemAdmin
      SystemAdmin
      1632 Posts
      ACCEPTED ANSWER

      Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

      ‏2013-02-01T22:05:05Z  in response to loicjulien
      Luic:

      Thanks very much for the reply.

      You are right, I had installed a 64-bit version of Data Studio on Windows 7 because that is all that was available. On my laptop I had installed 32-bit version of Data Studio (version 3.1.1). Version 3.2 does not seem to have a 32-bit version for Windows.

      Hence I uninstalled both DB2 and Data Studio 3.2. I then reinstalled the 32 bit version of DB2 server (with db2admin account created instead of local system account) and the 32-bit version of Data Studio 3.1.1. I created a sample database by first logging into db2admin account. I then logged back into my regular windows account and opened Data Studio 3.1.1.

      I was able to connect to the SAMPLE database. However, I still have a problem creating a new database. This is how I am doing it.

      I right click on the DB2 node in Data Studio and on the dialog screen I enter my user name db2admin and supply the password. I then click on Test connection button. It gives the following error message:

      The connectivity libraries that are need for local or remote non-JDBC operations were not found. To provide these libraries, you can install IBM Data Server Client or a local DB2 database server instance.

      What is the meaning of this message? I thought I have done what it is complaining about. I thought the Data Studio is the client and I have installed a DB2COPY1 and DB2 instance. This same installation procedure was followed on my laptop where I am able to create a new empty database. The only difference is that the laptop is not connected to a domain unlike this machine where the problem is occurring.

      Thanks for your help in advance.
    • SystemAdmin
      SystemAdmin
      1632 Posts
      ACCEPTED ANSWER

      Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

      ‏2013-02-01T22:05:41Z  in response to loicjulien
      I misspelled your name. Please accept my sincere apologies. I know it is Loic.
    • SystemAdmin
      SystemAdmin
      1632 Posts
      ACCEPTED ANSWER

      Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

      ‏2013-02-01T22:40:02Z  in response to loicjulien
      Loic:

      Update. I was able to create a new database using the command console. I issued the command "create database mktest". I then was able to connect to it within Data Studio. Why does it not work within Data Studio? Some problem with Path, Environment variable etc.?

      Thanks much.

      Murali
      • loicjulien
        loicjulien
        96 Posts
        ACCEPTED ANSWER

        Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

        ‏2013-02-01T23:50:24Z  in response to SystemAdmin
        Hi Murali,

        1/ Let me first summarize the situation:

        On Windows:
        (1) 32-bit Data Studio --> we leverage DAS (db2admin start) --> 32 bit DB2: Working configuration
        (2) 32-bit Data Studio --> we leverage DAS (db2admin start) --> 64 bit DB2: Working configuration
        (3) 64-bit Data Studio --> we leverage DAS (db2admin start) --> 64-bit DB2: Working configuration
        (4) 64-bit Data Studio --> we leverage DAS (db2admin start) --> 32-bit DB2: Not a working configuration

        => For the configuration that isn't supported, currently, the error message is: "The connectivity libraries that are needed for local or remote non-JDBC operations were not found. To provide these libraries, you can install IBM Data Server Client or a local DB2 database server instance.". Unfortunately, this message is not really clear about what is exactly going on.

        2/ Data Studio 3.2 does support 32 bits. When you install Data Studio 3.2 with IBM Installation Manager, there is a panel for the architecture you want to support (I am including a screencap below).

        3/ On connection, we always leverage JDBC (with the JCC driver), so I would expect connection to be successful. However, if we cannot rely on DAS locally, then, none of our CLP command support will be executable (such as the CREATE DATABASE command).

        To move you forward faster, I propose that you send me an email at lj@us.ibm.com and I'll schedule a screen share.

        Thanks,
        ~Loic
        • SystemAdmin
          SystemAdmin
          1632 Posts
          ACCEPTED ANSWER

          Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

          ‏2013-02-02T00:03:53Z  in response to loicjulien
          Hi Loic:

          My sincere thanks for such a quick reply. I will write to you over the weekend and we can do a screen share either Monday or Tuesday; whichever day is convenient to you.

          Best,
          Murali
          • YuanFeng
            YuanFeng
            61 Posts
            ACCEPTED ANSWER

            Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

            ‏2013-02-04T06:41:08Z  in response to SystemAdmin
            The problem looks wrong path for db2dasjutil.dll.It is under the <DB2 isntall folder>/sqllib/bin/
            but 64 bit will use the db2dasjutil64.dll

            <Data Studio install Folder>/jdk/jre/bin/java -version. see which jdk version are you using.

            The local db2 library doesn't have 64bit library for a 64 bit data studio will cause can't find the das library.
          • YuanFeng
            YuanFeng
            61 Posts
            ACCEPTED ANSWER

            Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

            ‏2013-02-04T07:28:43Z  in response to SystemAdmin
            The problem looks wrong path for db2dasjutil.dll or db2dasjutil64.dll
            could you check

            <DB2 isntall folder>\SQLLIB\java\jdk\bin\java -version

            <Data Studio install Folder>/jdk/jre/bin/java -version
            Please double check the environment PATH point to which sqllib,thanks.
            • SystemAdmin
              SystemAdmin
              1632 Posts
              ACCEPTED ANSWER

              Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

              ‏2013-02-04T20:30:12Z  in response to YuanFeng
              Dear YuanFeng:

              Here is a portion of my system path:

              c:\program files (x86)\ibm\gsk8\lib;C:\Program Files (x86)\IBM\SQLLIB\java;C:\PROGRA~2\IBM\SQLLIB\BIN;C:\PROGRA~2\IBM\SQLLIB\FUNCTION;C:\PROGRA~2\IBM\SQLLIB\SAMPLES\REPL

              Again, I have installed DB2 Express-C 32 bit with 32-bit Data Studio version 3.1.1.

              Do let me know if you see anything wrong in the path above.

              Thanks.
            • SystemAdmin
              SystemAdmin
              1632 Posts
              ACCEPTED ANSWER

              Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 64

              ‏2013-02-04T20:54:08Z  in response to YuanFeng
              Also, I provide below the output from checking for Java version:

              C:\Program Files (x86)\IBM\SQLLIB\java\jdk\jre\bin>java -version
              java version "1.7.0"
              Java(TM) SE Runtime Environment (build pwi3270-20110906_01)
              IBM J9 VM (build 2.6, JRE 1.7.0 Windows 7 x86-32 20110810_88604 (JIT enabled, AO
              T enabled)
              J9VM - R26_Java726_GA_20110810_1208_B88592
              JIT - r11_20110810_20466
              GC - R26_Java726_GA_20110810_1208_B88592
              J9CL - 20110810_88604)
              JCL - 20110809_01 based on Oracle 7b147

              Data Studio below:

              C:\Program Files (x86)\IBM\DS3.1.1\jdk\jre\bin>java -version
              java version "1.6.0"
              Java(TM) SE Runtime Environment (build pwi3260sr10-20111208_01(SR10))
              IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows 7 x86-32 jvmwi3260sr10-201112
              07_96808 (JIT enabled, AOT enabled)
              J9VM - 20111207_096808
              JIT - r9_20111107_21307ifx1
              GC - 20110519_AA)
              JCL - 20111104_02

              Thanks again.