How to automaticaly start DB2 after reboot of Linux

grofaty · #1 (**permalink**) 04-12-07, 02:00

Hi,
I have installed DB2 v9.1 on Red Hat Linux. Installation completed successfully. But after reboot I need to start DB2 manually. How to set automatic start up of DB2 on Linux?
Thanks,
Grofaty

Marcus_A · #2 (**permalink**) 04-12-07, 02:15

See the db2iauto command as described in the Command Reference manual.

grofaty · #3 (**permalink**) 04-12-07, 03:10

Hi,

1. I have listed the instances by command: "db2ilist". I got result "db2inst1"
2. I have executed command "db2iauto -on db2inst". No error was returned and db2set variable "DB2AUTOSTART=YES" was automatically created.
3. I have rebooted Linux and the database after reboot still doesn't start automatically. Have I missed something?

Thanks,
Grofaty

guyprzytula · #4 (**permalink**) 04-12-07, 03:54

this setting is used when instance comes down for autostart at boot :
- there is a process : db2fmcd : fault monitor coordinating daemon
- controlled from initab file (for unix ..)
in the structure of linux where processes are started at boot time
(/etc/init.d..) you should create a file that will start db2 similar to startup of other processes and a file to stop db2 (sxxxxx and kxxxxx) no samples shipped with db2 anymore.
it should contain : su -c db2inst1 "db2start"
this will start db2
keeping db2 up is controlled by db2fmcd

grofaty · #5 (**permalink**) 04-12-07, 08:25

Hi,
1. in file /etc/inittab there is the following data:

Code:

fmc:2345:respawn:/opt/ibm/db2/V9.1/bin/db2fmcd #DB2 Fault Monitor Coordinator

2. I have created the file /etc/init.d/db2 assign privileges (chmod 777 db2) and put into the following commands:

Code:

#! /bin/sh
. /home/db2inst1/sqllib/db2profile
su -c /opt/ibm/db2/V9.1/adm/db2start db2inst1

3. Reboot Linux and DB2 still doesn't start.

By the way I have executed the /etc/init.d/db2 manually and DB2 starts successfully. It just looks like /etc/init.d/db2 file is not executed at startup.

Any idea?

guyprzytula · #6 (**permalink**) 04-12-07, 11:20

is this the correct path ?
according to me, there are some subdirectories that specify the startup/boot mode of linux /etc/rc5.d is normal start of linux..
this directory keeps link to file, doing the startup
or see for another example
http://www.raibledesigns.com/tomcat/boot-howto.html

stolze · #7 (**permalink**) 04-12-07, 14:31

@grofaty: have you tried the supported way, i.e. "db2iauto"?

grofaty · #8 (**permalink**) 04-13-07, 04:03

Hi,
sorry, I started working on Red Hat Linux at customer, but at my company I continued to work on Ubuntu 6.10 Linux x86. I just assumed the Linux is Linux, but...

I found out there are some differences between Red Hat and Ubuntu. I have also got answer from IBM lab there is a problem of auto-start DB2 on Ubuntu, but I manage to work it anyway. I have posted the solution to DB2 IBM forum.

So problem solved, thank you very much for hints ant tips.
Lp,
Igor

grofaty · #9 (**permalink**) 04-13-07, 04:08

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Internet Services

Web Development

Digital Marketing

Consumer Tech