10110https://www.ibm.com/developerworks/community/forums/atom/replies?topicUuid=77777777-0000-0000-0000-000014935297Cannot create a new DB with Local System Account on Windows 7 Enterprise 64 Replies2013-02-04T20:54:08.921ZIBM Connections - Discussion Forumurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936950Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T20:54:08.921ZSystemAdmin110000D4XKactive2013-02-04T20:54:08.921Z
Also, I provide below the output from checking for Java version:<br />
<br />
C:\Program Files (x86)\IBM\SQLLIB\java\jdk\jre\bin&gt;java -version<br />
java version "1.7.0"<br />
Java(TM) SE Runtime Environment (build pwi3270-20110906_01)<br />
IBM J9 VM (build 2.6, JRE 1.7.0 Windows 7 x86-32 20110810_88604 (JIT enabled, AO<br />
T enabled)<br />
J9VM - R26_Java726_GA_20110810_1208_B88592<br />
JIT - r11_20110810_20466<br />
GC - R26_Java726_GA_20110810_1208_B88592<br />
J9CL - 20110810_88604)<br />
JCL - 20110809_01 based on Oracle 7b147<br />
<br />
Data Studio below:<br />
<br />
C:\Program Files (x86)\IBM\DS3.1.1\jdk\jre\bin&gt;java -version<br />
java version "1.6.0"<br />
Java(TM) SE Runtime Environment (build pwi3260sr10-20111208_01(SR10))<br />
IBM J9 VM (build 2.4, JRE 1.6.0 IBM J9 2.4 Windows 7 x86-32 jvmwi3260sr10-201112<br />
07_96808 (JIT enabled, AOT enabled)<br />
J9VM - 20111207_096808<br />
JIT - r9_20111107_21307ifx1<br />
GC - 20110519_AA)<br />
JCL - 20111104_02<br />
<br />
Thanks again.
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936940Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T20:30:12.720ZSystemAdmin110000D4XKactive2013-02-04T20:30:12.720Z
Dear YuanFeng:<br />
<br />
Here is a portion of my system path:<br />
<br />
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<br />
<br />
Again, I have installed DB2 Express-C 32 bit with 32-bit Data Studio version 3.1.1.<br />
<br />
Do let me know if you see anything wrong in the path above.<br />
<br />
Thanks.
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936604Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T07:28:43.970ZYuanFeng2700030G5Dactive2013-02-04T07:28:43.970Z
The problem looks wrong path for db2dasjutil.dll or db2dasjutil64.dll<br />
could you check<br />
<br />
&lt;DB2 isntall folder&gt;\SQLLIB\java\jdk\bin\java -version<br />
<br />
&lt;Data Studio install Folder&gt;/jdk/jre/bin/java -version<br />
Please double check the environment PATH point to which sqllib,thanks.
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936588Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-04T06:41:08.642ZYuanFeng2700030G5Dactive2013-02-04T06:41:08.642Z
The problem looks wrong path for db2dasjutil.dll.It is under the &lt;DB2 isntall folder&gt;/sqllib/bin/<br />
but 64 bit will use the db2dasjutil64.dll<br />
<br />
&lt;Data Studio install Folder&gt;/jdk/jre/bin/java -version. see which jdk version are you using.<br />
<br />
The local db2 library doesn't have 64bit library for a 64 bit data studio will cause can't find the das library.
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936368Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-02T00:03:53.290ZSystemAdmin110000D4XKactive2013-02-02T00:03:53.290Z
Hi Loic:<br />
<br />
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.<br />
<br />
Best,<br />
Murali
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936366Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T23:50:24.427Zloicjulien2700007DEBactive2013-02-01T23:50:24.427Z2013-04-14T18:23:09.944Z2013-04-14T18:23:09.944Z
Hi Murali,<br />
<br />
1/ Let me first summarize the situation:<br />
<br />
On Windows:<br />
(1) 32-bit Data Studio --&gt; we leverage DAS (db2admin start) --&gt; 32 bit DB2: Working configuration<br />
(2) 32-bit Data Studio --&gt; we leverage DAS (db2admin start) --&gt; 64 bit DB2: Working configuration <br />
(3) 64-bit Data Studio --&gt; we leverage DAS (db2admin start) --&gt; 64-bit DB2: Working configuration<br />
(4) 64-bit Data Studio --&gt; we leverage DAS (db2admin start) --&gt; 32-bit DB2: Not a working configuration<br />
<br />
=&gt; 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.<br />
<br />
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).<br />
<br />
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).<br />
<br />
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.<br />
<br />
Thanks,<br />
~Loic
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936356Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T22:40:02.051ZSystemAdmin110000D4XKactive2013-02-01T22:40:02.051Z
Loic:<br />
<br />
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.?<br />
<br />
Thanks much.<br />
<br />
Murali
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936353Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T22:05:41.655ZSystemAdmin110000D4XKactive2013-02-01T22:05:41.655Z
I misspelled your name. Please accept my sincere apologies. I know it is Loic.
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014936352Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-02-01T22:05:05.166ZSystemAdmin110000D4XKactive2013-02-01T22:05:05.166Z
Luic:<br />
<br />
Thanks very much for the reply. <br />
<br />
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. <br />
<br />
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.<br />
<br />
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.<br />
<br />
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:<br />
<br />
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.<br />
<br />
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. <br />
<br />
Thanks for your help in advance.
none, view_forum, view_categoryurn:lsid:ibm.com:forum:77777777-0000-0000-0000-000014935751Re: Cannot create a new DB with Local System Account on Windows 7 Enterprise 642013-01-31T19:14:31.337Zloicjulien2700007DEBactive2013-01-31T19:14:31.337Z
Hi Murali,<br />
<br />
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.<br />
<br />
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. <br />
<br />
My assumptions:<br />
1- You are running the latest version of Data Studio. Data Studio 3.2<br />
2- DAS, on the server side, is started: db2admin start<br />
<br />
I propose to first validate:<br />
1/ Run db2level in the CLP to make sure it is indeed the 32 bits version.<br />
2/ In your Windows menu, under IBM Installation Manager -&gt; "View installed packages", review the Package Group Architecture for Data Studio 3.2. Again, based on your description, should be 32 bits<br />
<br />
Let me know if this helps,<br />
~Loic (lj@us.ibm.com)
none, view_forum, view_category