IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 10 replies
  • Latest Post - ‏2013-02-04T20:54:08Z by SystemAdmin
SystemAdmin
SystemAdmin
1632 Posts

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

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

    ‏2013-01-31T19:14:31Z  
    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

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

    ‏2013-02-01T22:05:05Z  
    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)
    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

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

    ‏2013-02-01T22:05:41Z  
    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)
    I misspelled your name. Please accept my sincere apologies. I know it is Loic.
  • SystemAdmin
    SystemAdmin
    1632 Posts

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

    ‏2013-02-01T22:40:02Z  
    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)
    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

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

    ‏2013-02-01T23:50:24Z  
    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
    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

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

    ‏2013-02-02T00:03:53Z  
    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
    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
    78 Posts

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

    ‏2013-02-04T06:41:08Z  
    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
    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
    78 Posts

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

    ‏2013-02-04T07:28:43Z  
    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
    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

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

    ‏2013-02-04T20:30:12Z  
    • YuanFeng
    • ‏2013-02-04T07:28:43Z
    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.
    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

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

    ‏2013-02-04T20:54:08Z  
    • YuanFeng
    • ‏2013-02-04T07:28:43Z
    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.
    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.