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.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
10 replies Latest Post - 2013-02-04T20:54:08Z by SystemAdmin
Pinned topic Cannot create a new DB with Local System Account on Windows 7 Enterprise 64
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-04T20:54:08Z at 2013-02-04T20:54:08Z by SystemAdmin
loicjulien 2700007DEB96 PostsACCEPTED ANSWER
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-01-31T19:14:31Z in response to SystemAdminHi 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.
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,
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T22:05:05Z in response to loicjulienLuic:
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.
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T22:40:02Z in response to loicjulienLoic:
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.?
loicjulien 2700007DEB96 PostsACCEPTED ANSWER
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T23:50:24Z in response to SystemAdminHi Murali,
1/ Let me first summarize the situation:
(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 firstname.lastname@example.org and I'll schedule a screen share.
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-02T00:03:53Z in response to loicjulienHi 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.
YuanFeng 2700030G5D78 PostsACCEPTED ANSWER
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T06:41:08Z in response to SystemAdminThe 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 2700030G5D78 PostsACCEPTED ANSWER
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T07:28:43Z in response to SystemAdminThe 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.
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T20:30:12Z in response to YuanFengDear 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.
Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T20:54:08Z in response to YuanFengAlso, 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
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