Pinned topic DB2 Express-C 10.1.0.2 instance not auto starting
I'm using DB2 Express-C 10.1.0.2 on Linux. During the installation I set that the instance should be auto-started, but after reboot it is not.
What am I missing?
Re: DB2 Express-C 10.1.0.2 instance not auto starting2013-01-29T07:54:02ZThis is the accepted answer. This is the accepted answer.Hi!
What I found till now is that DB2 fault monitor is responsible for autostarting DB2 instance.
There is a command db2fm that can maintain db2fmcd (DB2 fault monitor deamon).
At boot time I see that db2fmcd is running, but is not starting DB2 instance.
"sudo ./db2fm -s -S" gives:
Gcf module 'fault monitor' is INSTALLED PROPERLY but NOT ALIVE
Gcf module '/opt/ibm/db2/V10.1/lib64/libdb2gcf.so' is INSTALLED PROPERLY but NOT ALIVE
If I bring the service and deamon up using
sudo ./db2fm -u -U
DB2 instance is started.
dmesg gives me a lot of this lines:
db2fmcd1094 general protection ip:7f06966e5154 sp:7fff2e2f2150 error:0 in libc-2.15.so7f0696677000+1b3000
init: db2fmcd main process (1094) killed by SEGV signal
init: db2fmcd main process ended, respawning
Re: DB2 Express-C 10.1.0.2 instance not auto starting2013-01-29T08:25:57ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Workaround for this is to pu following lines to /etc/rc.local
./db2fm -i db2inst1 -u -U
./db2fm -i db2inst1 -s -S
Now DB2 instance is started at boot time and even if I kill the db2syscs process it comes back. :)
This does not solve the crashing of db2fmcd process, but gets your instance running.
JohnHarris 2700029YEU1 Post
Re: DB2 Express-C 10.1.0.2 instance not auto starting2014-05-14T14:21:36ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Auto starting/stopping DB2 on Linux/Unix
Log in as root and enter the following commands
su - db2inst1 à where db2inst1 is ID of the instance owner
Setting DB2 to automatically start at system reboot
db2iauto -on db2inst1 -à where db2inst1 is name of the instance that should be auto-started
Setting DB2 not to automatically start at system reboot
db2iauto -off db2inst1
On some instances of Linux it might be necessary to update the DB2 registry AUTOSTART (undocumented) / DB2AUTOSTART variables
Check whether or not the auto starting variables are set
MyLinux:~ # su - db2inst1
db2inst1@MyLinux:~> db2set -all
Manually verify the AUTOSTART and DB2AUTOSTART registry variables set for the instance
- db2set DB2AUTOSTART [-i instance_name]
- db2set AUTOSTART [-i instance_name]
db2inst1@MyLinux:~> db2set AUTOSTART -i db2inst1
db2inst1@ MyLinux:~> db2set DB2AUTOSTART -i db2inst1
The above commands should return YES if they are currently set
If it doesn't issue the following commands
- db2set AUTOSTART=YES
- db2set DB2AUTOSTART=YES
- db2iauto -on instance_name
John HarrisUpdated on 2014-05-14T14:22:04Z at 2014-05-14T14:22:04Z by JohnHarris