DB2 on Linux

nabil · 02-05-2003, 05:28 PM

Hi, I am new to DB2 on Linux ... Any idea how to allow other none instant owners accounts connect to databases localy via db2 interface ???
Here is what happens:

Code:

-bash-2.05b$ db2 connect to sample 
SQL10007N Message "-1390" could not be retrieved.  Reason code: "1". 
-bash-2.05b$

But using db2inst1 account:

Code:

[db2inst1@viper db2inst1]$ db2 connect to sample 

   Database Connection Information 

Database server        = DB2/LINUX 8.1.0 
SQL authorization ID   = DB2INST1 
Local database alias   = SAMPLE 

[db2inst1@viper db2inst1]$

tarballed · 02-18-2003, 01:20 PM

nabil,

I am also new to DB2 on Linux. I have a question for you. I am currently in the processes of installing DB2 on a RH 8.0 box. I have it all installed, but I am having a problem getting the control center up and running. We wanted to play with the GUI a little to get a feel for it.

After the install, it says to run the db2fs command to check everything. Well, this is where the problem is: That command is not working.

Here is what happens when I try and execute the command:

./db2fs: line 14: db2javit: command not found

Do you have any idea on what that may be?
Can I provide any information that may help resolve this?

Thanks.

Tarballed

nabil · 02-18-2003, 05:43 PM

hi Tarballed,

Unfortunantly I am no db2 expert either .. I have installed db2 for the first time and don't know what I am doing yet ...
But don't recall that I had any issues at all installing db2 8.1 on RedHat 8.0 ....It appears that you problem may be because you are not logged in as the db2inst1 account thus can's find the path to db2 bin files ....Good luck, I am still trying to find answers my self ...

tarballed · 02-18-2003, 07:17 PM

nabil,

Just out of curiosity, can you tell me how you installed DB2 on RH 8.0? I am attempting to install version 8.0 of DB.

I downloaded the tarball from IBM and untarred it into a temporary directory.

I just want to see what I may be doing that is incorrect.

Can you tell me how you started the installation? Did you install from a CD? Or did you install from the tarball?
Hopefully, I can pinpoint my problem if I am doing something wrong with the installation.
Thanks.

Tarballed

nabil · 02-18-2003, 07:59 PM

Actually, I don't even rememmber all the details, I did download the tar ball from IBM web site and followed the readme file. but mainly it was straight forward and based on the readme file ..nothing special ...You export your display so that the java installer can work and from there you follow the on screen instructions ..No special thing to rememeber before or after ...Sorry .. I did this like a couple of months ago. I was not planing to really learn db2 at the time ..just goofing around......I do know that it was much easier than installing the 7.1 version ...the 8.1 was java GUI driven and more user friendly ...BTW do you have java installed in your system ??? Maybe that's why java GUIis not working out for you ... I previously downloaded the java sdk binaries from sun Microsystem web site for an Oracle server installation... j2sdk1.4.1_01 and exported this into my root bash_profile
JAVA_HOME=/usr/local/java as simbolic link to j2sdk1.4.1_01

What problem are you having to get started with the installer ????

GtkUser · 02-18-2003, 11:26 PM

Installing Java on RH 8.0? < http://members.shaw.ca/trollking >.

tarballed · 02-19-2003, 10:50 AM

Ok. I am not sure what exactly is going on, but it is really starting to irritate me.

I downloaded and installed DB2 onto my RH 8.0 box. I followed the instructions. Simple enough.

After that, I tried to start the control center. I went to execute the file db2cc that is inside the db2 directory. At first, when I tried executing it, it came up with "db2javit; command not found."

I did a find for db2javit and found the path to it. The full path was:

/opt/IBM/db2/V8.1/bin <--where DB2 is installed.

I put the path into my profile. Once I did that, I tried executing the file again. This time, this is what I got:

DB2JAVIT : RC = 9501
DB2INSTANCE : -2029059916

Ok. From what I read on the instructions, DB2 8.1 needs java 1.3 or higher. I d/l the IBM developers kit and installed the RPM's.

But, as we can see, something is still not correct.

Any ideas? Do you need additional information?
Let me know and I can post whatever is needed.

Thanks.

Tarballed

nabil · 02-19-2003, 06:37 PM

Tarballed,
have you installed the sample db by any chance ??? can you connet to it and maybe run some queries ??? I am still unable to determin what problems are you having ????

nabil · 02-24-2003, 06:12 PM

BTW: I have figured out my issue,
By adding this line to .bash_profile has done the trick for me.

PHP Code:



. /home/db2inst1/sqllib/db2profile

tarballed · 02-24-2003, 06:28 PM

nabil,

I figured out my problem. It was really quite funny actually.

The problem was that I was logging in with a regular user and trying to start the Control Center. Once I logged in with a user that was created during install, all my problems were solved. Or, they were somewhat.

Now I am trying to connect to the DB remotely to do some testing. Have not had a lot of time to do testing, but if I run into some snags, I will post a few questions.

Thanks for your help.

Tarballed

byfaithalone · 10-13-2003, 01:59 PM

Nabil,

I use SUSE 8.2. Where can I find this .bash_profile?

gledesma · 11-22-2005, 09:09 PM

Quote:

Originally posted by tarballed
Ok. I am not sure what exactly is going on, but it is really starting to irritate me.

I downloaded and installed DB2 onto my RH 8.0 box. I followed the instructions. Simple enough.

After that, I tried to start the control center. I went to execute the file db2cc that is inside the db2 directory. At first, when I tried executing it, it came up with "db2javit; command not found."

I did a find for db2javit and found the path to it. The full path was:

/opt/IBM/db2/V8.1/bin <--where DB2 is installed.

I put the path into my profile. Once I did that, I tried executing the file again. This time, this is what I got:

DB2JAVIT : RC = 9501
DB2INSTANCE : -2029059916

Ok. From what I read on the instructions, DB2 8.1 needs java 1.3 or higher. I d/l the IBM developers kit and installed the RPM's.

But, as we can see, something is still not correct.

Any ideas? Do you need additional information?
Let me know and I can post whatever is needed.

Thanks.
Tarballed

Hi

If you are using 64 bits linux platform, the problem is with DB2 tools (like db2cc, etc), as you can see in the following URL.
http://www-1.ibm.com/support/docview...id=swg1LI70572

Regards
Gustavo Ledesma
www.isetec.com.mx