473,544 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

installing DB2 on Linux

I recently installed DB2 v8.1 on Linux. The installation went
smoothly. I can now connect to the "sample" database and work with
it.

However, I noticed the following. How do I go about fixing these?

1) When in db2, if the SQL statements contain a syntax error, the
whole application crashes. This happens, for example, if I type
"select * from emps" where the table emps does not exist.

2) db2cc does not start, gives error messages about "Can't find
library
db2jdbc (libdb2jdbc.so) "

3) db2ca does not start. It too gives error messages about some java
class: "Can't find library db2adtca (libdb2adtca.so ) in
java.library.pa th"

4) How do I stop/start instances?
Nov 12 '05 #1
8 5123
tu*****@yahoo.c om wrote:
I recently installed DB2 v8.1 on Linux. The installation went
smoothly. I can now connect to the "sample" database and work with
it.

However, I noticed the following. How do I go about fixing these?

1) When in db2, if the SQL statements contain a syntax error, the
whole application crashes. This happens, for example, if I type
"select * from emps" where the table emps does not exist.
That should not happen:

db2 => select * from emps;
SQL0204N "JDBEYER.EM PS" is an undefined name. SQLSTATE=42704
db2 =>

2) db2cc does not start, gives error messages about "Can't find
library
db2jdbc (libdb2jdbc.so) "
I do not use db2cc; got in the habit of not using that in V6.1 days when
it ran so slowly that I could not stand it.

Did you install it?

trillian:jdbeye r[~]$ locate libdb2jdbc.so
/opt/IBM/db2/V8.1/lib/libdb2jdbc.so
/opt/IBM/db2/V8.1/lib/libdb2jdbc.so.1
3) db2ca does not start. It too gives error messages about some java
class: "Can't find library db2adtca (libdb2adtca.so ) in
java.library.pa th"
trillian:jdbeye r[~]$ locate libdb2adtca.so
/opt/IBM/db2/V8.1/lib/libdb2adtca.so
/opt/IBM/db2/V8.1/lib/libdb2adtca.so. 1 4) How do I stop/start instances?


db2istrt

In Red Hat Enterprise Linux 3 ES, I have a file in /etc/rc.d/init.d for
that. Named IBMdb2. It is like this:

#!/bin/sh
# chkconfig: 35 98 02
# description: Start and Stop IBM's db2 dbms.
BASE=/opt/IBM/db2
VERSION=V8.1
INSTANCE=/dataA/db2inst1 # Where (a small part of the) instance will be.
# Set the path.
PATH=/sbin:/bin:/usr/bin:/usr/sbin
.. /etc/rc.d/init.d/functions
# Check we have the start and stop programs.
test -x $INSTANCE/sqllib/adm/db2start || exit 0
test -x $INSTANCE/sqllib/adm/db2stop || exit 0
test -x $BASE/$VERSION/bin/db2 || exit 0
case "$1" in
start)
# Check if IBMdb2 not already running
if [ ! -f /var/lock/subsys/IBMdb2 ]; then
echo -n 'Starting IBMdb2 daemons: '
su - db2inst1 -c $INSTANCE/sqllib/adm/db2start
echo
touch /var/lock/subsys/IBMdb2
fi
;;
stop)
# We first try twice to kill all existing applications.
# There really should be none most of the time.
echo 'Stopping IBMdb2 daemons: '
su - db2inst1 -c "$BASE/$VERSION/bin/db2 FORCE APPLICATION ALL"
sleep 2
su - db2inst1 -c "$BASE/$VERSION/bin/db2 FORCE APPLICATION ALL"
sleep 2
su - db2inst1 -c $INSTANCE/sqllib/adm/db2stop
echo
rm -f /var/lock/subsys/IBMdb2
;;
reload|restart)
$0 stop
sleep 3
$0 start
;;
*)
echo "Usage: /etc/rc.d/init.d/IBMdb2 {start|stop|res tart|reload}"
exit 1
esac
#-----------------------------------------------------------------------
# Exit successfully.
#-----------------------------------------------------------------------
exit 0
~

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 12:55:00 up 7 days, 22:36, 5 users, load average: 4.16, 4.12, 4.09

Nov 12 '05 #2
<tu*****@yahoo. com> wrote in message
news:32******** *************** ***@posting.goo gle.com...
I recently installed DB2 v8.1 on Linux. The installation went
smoothly. I can now connect to the "sample" database and work with
it.

However, I noticed the following. How do I go about fixing these?

1) When in db2, if the SQL statements contain a syntax error, the
whole application crashes. This happens, for example, if I type
"select * from emps" where the table emps does not exist.

2) db2cc does not start, gives error messages about "Can't find
library
db2jdbc (libdb2jdbc.so) "

3) db2ca does not start. It too gives error messages about some java
class: "Can't find library db2adtca (libdb2adtca.so ) in
java.library.pa th"

4) How do I stop/start instances?


Need more info on which Linux you are using. If using RH9 or equivalent,
check the google groups archive for tips on getting it to work (DB2 is not
officially supported on RH9).
Nov 12 '05 #3
tu*****@yahoo.c om wrote in message news:<32******* *************** ****@posting.go ogle.com>...
I recently installed DB2 v8.1 on Linux. The installation went
smoothly. I can now connect to the "sample" database and work with
it.

However, I noticed the following. How do I go about fixing these?

1) When in db2, if the SQL statements contain a syntax error, the
whole application crashes. This happens, for example, if I type
"select * from emps" where the table emps does not exist.

2) db2cc does not start, gives error messages about "Can't find
library
db2jdbc (libdb2jdbc.so) "
Do you have java installed on the system? I remember when I first
tried to use db2cc and db2dc on my linux laptop, I didn't have the
correct version of Java installed. After installing the rpms ( I use
RH9 ) for Java 1.3.2 I believe, I still was missing a link. I created
a symbolic link in /opt/IBM/db2/V8.1/ someplace and everything started
fine after that. I forget where right now and I don't have it in
front of me, but I know I found the missing link info in the DB2
information center on the web.

Sorry I can't be more helpful, but I can post more info on Monday if
you still need help.

Otherwise you can start/stop DB2 by executing the
/INSTANCE_OWNER_ HOME/sqllib/db2profile in you current shell and then
just type db2start or db2stop.


3) db2ca does not start. It too gives error messages about some java
class: "Can't find library db2adtca (libdb2adtca.so ) in
java.library.pa th"

4) How do I stop/start instances?

Nov 12 '05 #4
I got the db2 command line to work. I am not sure what I did but I was
trying the commands in the shell script.

As far as the the db2cc and db2ca, they still do not work. The locate
command returns nothing. How do I install them?

Thanks!

Nov 12 '05 #5
Mark,

I am using Mandrake 9.2. I realize this is not an officially supported
distro, but this is for personal use and for learning. It installed fine,
actually, and is working apart from db2cc/db2ca tools.
Nov 12 '05 #6
I believe I have Java installed. As you noted, it may be a different
version, though.. I will look into it. If you could post more info on
Monday, I'd appreciate it.

Thanks!
Nov 12 '05 #7
> Mark,

I am using Mandrake 9.2. I realize this is not an officially supported
distro, but this is for personal use and for learning. It installed fine,
actually, and is working apart from db2cc/db2ca tools.

No, it did install fine. Go to the newsgroup archive on Google and find the
instructions like I told you to. The Java stuff will not work unless you do
some workaround steps, because DB2 does not work properly with Linux version
9. The reason it is not "supported" is because it does not work properly
with Linux 9 (yes, IBM tested it). But you can get it to install correctly
with the workarounds.
Nov 12 '05 #8
"Mark A" <no****@nowhere .com> wrote in message
news:IY******** *********@news. uswest.net...
Mark,

I am using Mandrake 9.2. I realize this is not an officially supported
distro, but this is for personal use and for learning. It installed fine, actually, and is working apart from db2cc/db2ca tools.
No, it did install fine. Go to the newsgroup archive on Google and find

the instructions like I told you to. The Java stuff will not work unless you do some workaround steps, because DB2 does not work properly with Linux version 9. The reason it is not "supported" is because it does not work properly
with Linux 9 (yes, IBM tested it). But you can get it to install correctly
with the workarounds.

Correction:

No, it did NOT install fine.
Nov 12 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4907
by: Jean-Christian Imbeault | last post by:
I have a user account on a RH Linux machine but no root access. I succesfully installed apache 1.3 under my /home/ account but can't get PHP to install properly. I have done the following steps: #1 compiled and installed apache using --prefix=/home/imbeauje/apache. Tested that it works.
7
3196
by: Edward Diener | last post by:
I can install Python 2.4 on the Fedora 3 Linux system, but after I do a number of Linux utilities and commands, like yum, stop working because they were dependent on the Python 2.3 installation. What happens is that Python 2.4 replaces the /usr/bin/python module with the Python 2.4 version. If I replace /usr/bin/python with the Python 2.3...
0
620
by: Darren L. Weber | last post by:
The following is a first attempt to almost create a shell script for installation of ATLAS and LAPACK. It does not work right now and it is specific to a particular platform. It is posted here to archive it and throw into the public domain, maybe others will find it useful. It is at least a documentation of some relevant notes on the...
2
3368
by: Hemant Shah | last post by:
Folks, I have installed DB2 UDB 8.1 FP4 on a RedHat 9.0 system. I am trying to install Net Search Extender 8.1 but I am having problem with the install. Here is the error I get: # ./nsesetup.sh .....................
0
2032
by: bwhitehd | last post by:
I'm having a problem installing php. The compile seems to go fine, but when it gets to the install step I get the following errors. Does anyone have an idea of what might be the problem? We build our applications under three different environments (Linux i686, Linux x86_64, Solaris 8 Sparc). This is the first of the three on a RHEL 3...
1
2264
by: gmax2006 | last post by:
Hi, I am having hard time with installing MySQLdb on Linux. My Python version is 2.3. I have downloaded "MySQL-python-1.2.1_p2.tar.gz" from sourceforge. The README file asks for MySQL installation. My MySql server is on another box. That is why I think I should to install just the MySql client (am I right?). My Linux is "Red Hat...
7
1756
by: Yansky | last post by:
I asked my hosting company if they would upgrade Python on my server to the latest version. They responded with: "Sorry no. We tend to stick with what comes packaged with the unix distribution to ease maintenance issues. There is nothing stopping you from running your own version of python from within your own account. Download the source...
5
2197
by: jgelfand | last post by:
I'm installing Python 2.4.4 on a CentOS release 4.6 (Final) 64-bit machine. Running "./configure --prefix="/ usr/local/yosi/ciao-4.0/ots" --enable-shared" appears to be fine, but I get the following error message when I run "make": building '_tkinter' extension gcc -pthread -fPIC -fno-strict-aliasing -DNDEBUG -g -fwrapv -O3 -Wall -...
6
5559
by: everlast | last post by:
I'm installing BLT module (among others) in my directories - not as a root user. The installation of Tcl and Tk went fine(that means that all of my system variables like PREFIX are set correctly), but when I try to install BLT i get this error message with make: (cd src; make all) make: Entering directory...
2
3548
by: Ruslan A Dautkhanov | last post by:
Hello ! I'm about to install O9i on FreeBSD box. uname -a: FreeBSD stat2.scn.ru 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 rd@stat2.scn.ru:/usr/src/sys/i386/compile/RDSTAT2-ORACLE i386 uname -a under oracle user : Linux stat2.scn.ru 2.4.2 FreeBSD 5.2.1-RELEASE-p3 #2: Fri Apr 23 19:19:43 KRAST 2004 i686...
0
7362
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7602
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7368
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7704
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5904
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5291
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
4911
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3407
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
657
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.