Hi, I'm experimenting with DB2 on linux, after having successfully used Oracle for a while. I can't seem to find any documentation for configuring the environment for db2. The default users work ok, but I can't find any information on configuring the environments of other users to access DB2. I'm using a user other than the default DB2 users to develop a java app (with jdbc), but I clearly don't have the environment configured correctly. I have updated paths to include the DB2 binaries and library's, but can't even run the db2 executable from the command line as this user (see below).
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".
This is becoming sorta frustrating as this is all quite straight forward in oracle, but not it seems with DB2. Anyway has anyone experience with this, or could someone point me to documentation on the subject. Thanks in advance. Jeff
Hi Jeff, I am in the same boat as you - I have plenty of Oracle experience on Linux and Solaris, but I have recently had to use DB2, and have really run into roadblocks into finding any useful docs about getting this beast to work on Linux (or any other platform). I suppose that I have been spoiled by Oracle's excellent books that get a person up to speed quickly with the database. In the case of IBM DB2, there are the IBM Redbooks available on the IBM site; but you'll find that you really have to struggle to get through them just to understand what is going on. I haven't gotten that far, yet. Everything I find that is a book about DB2 is geared towards certification, not towards getting something up and running for development. To make a long story short, I can't point you anywhere but the IBM Redbooks available online at ibm.com. If you find anything, please let me know. Good luck, -ronc On Monday 15 April 2002 01:24 am, Jeff Hoare wrote:
Hi, I'm experimenting with DB2 on linux, after having successfully used Oracle for a while. I can't seem to find any documentation for configuring the environment for db2. The default users work ok, but I can't find any information on configuring the environments of other users to access DB2.
I'm using a user other than the default DB2 users to develop a java app (with jdbc), but I clearly don't have the environment configured correctly. I have updated paths to include the DB2 binaries and library's, but can't even run the db2 executable from the command line as this user (see below).
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".
This is becoming sorta frustrating as this is all quite straight forward in oracle, but not it seems with DB2.
Anyway has anyone experience with this, or could someone point me to documentation on the subject.
Thanks in advance.
Jeff
http://www.tldp.org/HOWTO/DB2-HOWTO/ http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/docu ment.d2w/report?fn=db2v7i4db2i426.htm http://plutonium.cs.umanitoba.ca/DB2Docs/db2help/index.htm#top Hope this helps. -----Original Message----- From: Ron Cordell [mailto:roncordell@attbi.com] Sent: Monday, April 15, 2002 10:19 AM To: jhoare@ihug.com.au; suse-linux-e@suse.com Subject: Re: [SLE] Configuring DB2 access Hi Jeff, I am in the same boat as you - I have plenty of Oracle experience on Linux and Solaris, but I have recently had to use DB2, and have really run into roadblocks into finding any useful docs about getting this beast to work on Linux (or any other platform). I suppose that I have been spoiled by Oracle's excellent books that get a person up to speed quickly with the database. In the case of IBM DB2, there are the IBM Redbooks available on the IBM site; but you'll find that you really have to struggle to get through them just to understand what is going on. I haven't gotten that far, yet. Everything I find that is a book about DB2 is geared towards certification, not towards getting something up and running for development. To make a long story short, I can't point you anywhere but the IBM Redbooks available online at ibm.com. If you find anything, please let me know. Good luck, -ronc On Monday 15 April 2002 01:24 am, Jeff Hoare wrote:
Hi, I'm experimenting with DB2 on linux, after having successfully used Oracle for a while. I can't seem to find any documentation for configuring the environment for db2. The default users work ok, but I can't find any information on configuring the environments of other users to access DB2.
I'm using a user other than the default DB2 users to develop a java app (with jdbc), but I clearly don't have the environment configured correctly. I have updated paths to include the DB2 binaries and library's, but can't even run the db2 executable from the command line
as this user (see below).
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".
This is becoming sorta frustrating as this is all quite straight forward in oracle, but not it seems with DB2.
Anyway has anyone experience with this, or could someone point me to documentation on the subject.
Thanks in advance.
Jeff
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com
Hiya, Well manager to get it working for my other user. This would work if the user is on the same machine as the DB server. You need to set the following environment variables: DB2INSTANCE=<whatever the instance is called db2inst1 if u use the default> LD_LIBRARY_PATH=<path to install>/lib:$LD_LIBRARY_PATH PATH=<path to install>/bin:$PATH Once these were set for my user I was able to get everything working. I found a redbook on setting up a web server environment on linux using DB2, websphere and Domino, apart from other things it had info on configuring client access. However, I've no doubt that there is a whole other nightmare waiting to configure remote access to the server. Jeff On Tue, 16 Apr 2002 00:19, Ron Cordell wrote:
Hi Jeff,
I am in the same boat as you - I have plenty of Oracle experience on Linux and Solaris, but I have recently had to use DB2, and have really run into roadblocks into finding any useful docs about getting this beast to work on Linux (or any other platform). I suppose that I have been spoiled by Oracle's excellent books that get a person up to speed quickly with the database.
In the case of IBM DB2, there are the IBM Redbooks available on the IBM site; but you'll find that you really have to struggle to get through them just to understand what is going on. I haven't gotten that far, yet. Everything I find that is a book about DB2 is geared towards certification, not towards getting something up and running for development.
To make a long story short, I can't point you anywhere but the IBM Redbooks available online at ibm.com. If you find anything, please let me know.
Good luck,
-ronc
On Monday 15 April 2002 01:24 am, Jeff Hoare wrote:
Hi, I'm experimenting with DB2 on linux, after having successfully used Oracle for a while. I can't seem to find any documentation for configuring the environment for db2. The default users work ok, but I can't find any information on configuring the environments of other users to access DB2.
I'm using a user other than the default DB2 users to develop a java app (with jdbc), but I clearly don't have the environment configured correctly. I have updated paths to include the DB2 binaries and library's, but can't even run the db2 executable from the command line as this user (see below).
SQL10007N Message "-1390" could not be retrieved. Reason code: "1".
This is becoming sorta frustrating as this is all quite straight forward in oracle, but not it seems with DB2.
Anyway has anyone experience with this, or could someone point me to documentation on the subject.
Thanks in advance.
Jeff
participants (3)
-
Jeff Hoare
-
Michael Garabedian
-
Ron Cordell