Archive | October, 2007

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