DB2 problems

4 Oct

If DB2 isn’t starting, look for log files in /tmp and also in the db2 user’s dir: e.g. /home/db2inst1/sqlib/log

V9.1 Enterprise Edition on Linux (CentOS) i was having troubles with commands hanging or freezing. It appeared that db2sysc would lock up with 100% of the CPU.

To fix this I did:

$> su - db2inst1
$> cd sqllib/bin
$> db2_kill
$> ipclean

then.. kill any remaining db2 processes (use

ps -ef | grep db2

and kill the PID’s)

then (as root):

$> cd /opt/IBMdb2/V7.1/instance
$>./db2iupdt 

I got this from: http://www.math.uwaterloo.ca/mfcf/internal/procedures/problems/db2-restart.html

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: