DB2 autostart under ubuntu 11.04

tweetysat · #1 (**permalink**) 08-05-11, 08:19

Hello.

I'm wondering why my db2 9.7 does not start automatically under ubuntu 11.04 (running into vmware - but I don't think it's important).

Of course I tried

Code:

db2iauto -on admin

... not working.

So I searched on internet and found that

But there is a problem.

So

Code:

./db2fmcu -u -p /opt/ibm/db2/V9.7/bin/db2fmcd

the file inittab contains

Code:

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

It's ok.

Then (my instance name is admin)

Code:

./db2fm -i admin -U
./db2fm -i admin -u
./db2fm -i admin -f on
./db2fm -s -S

->

Code:

Gcf module 'fault monitor' state is AVAILABLE
Gcf module '/opt/ibm/db2/V9.7/lib32/libdb2gcf.so' state is AVAILABLE

Reboot

Code:

./db2fmcu

->

Code:

FMC: down

and

Code:

./db2fm -s -S

->

Code:

Gcf module 'fault monitor' is INSTALLED PROPERLY but NOT ALIVE
Gcf module '/opt/ibm/db2/V9.7/lib32/libdb2gcf.so' is INSTALLED PROPERLY but NOT ALIVE

And of course db2 not starting.

So what can I do ?

przytula_guy · #2 (**permalink**) 08-05-11, 08:31

after the reboot you should find the process : db2fmcd coord-daemon
check with ps..
it is at the end of inittab - so it can take some minutes after the boot
if this process is not present - instance will not be started because daemon looks in reg file to see if instance need to be started..

tweetysat · #3 (**permalink**) 08-05-11, 08:39

ok, i did a ps -ef | grep db2fm

Code:

admin     2535     1  0 14:29 ?        00:00:00 /opt/ibm/db2/V9.7/bin/db2fmd -i admin -m /opt/ibm/db2/V9.7/lib32/libdb2gcf.so

So I suppose the is not working

What do you mean by look in reg file ? (I don't know very well linux).

n_i · #4 (**permalink**) 08-05-11, 08:49

Quote:

Originally Posted by tweetysat

Of course I tried

Code:

db2iauto -on db2inst1

... not working.

Then (my instance name is admin)

Code:

./db2fm -i admin -U
./db2fm -i admin -u
./db2fm -i admin -f on
./db2fm -s -S

If your instance name is admin, then that's what you should have used in db2iauto.

Use db2greg -dump to display the actual state of the instance (run db2greg without parameters do see the description of fields).

tweetysat · #5 (**permalink**) 08-05-11, 08:55

Hi

Sorry i did well db2iauto -on admin It's an error on this post. I will change it.

So db2greg -dump

Code:

S,DB2,9.7.0.4,/opt/ibm/db2/V9.7,,,4,0,,1312534376,0
V,DB2GPRF,DB2SYSTEM,Virtual-Ubuntu,/opt/ibm/db2/V9.7,
V,DB2GPRF,DB2_COMPATIBILITY_VECTOR,MYS,/opt/ibm/db2/V9.7,
S,DAS,9.7.0.4,/opt/ibm/db2/V9.7/das,lib/libdb2dasgcf.so,,4,, ,,
I,DAS,9.7.0.4,dasusr1,/home/dasusr1/das,,1,,/opt/ibm/db2/V9.7/das,,
V,DB2GPRF,DB2ADMINSERVER,dasusr1,/opt/ibm/db2/V9.7,
I,DB2,9.7.0.4,admin,/home/admin/sqllib,,1,0,/opt/ibm/db2/V9.7,,
V,DB2GPRF,DB2INSTDEF,admin,/opt/ibm/db2/V9.7,

przytula_guy · #6 (**permalink**) 08-05-11, 09:39

but executing ps you should see : db2fmcd
this can be started manually after boot also from indicated path with root
db2fmd is a process by istance or admin user

tweetysat · #7 (**permalink**) 08-05-11, 10:00

I tried

Code:

/opt/ibm/db2/V9.7/bin/db2fmcd

and now I've got

Code:

root      7491  6058  2 15:53 pts/0    00:00:00 /opt/ibm/db2/V9.7/bin/db2fmcd

But now ?

Why it's not starting at reboot ?

And now when I do

Code:

./dbfmcu

still

Code:

FMC: down

tweetysat · #8 (**permalink**) 08-08-11, 02:41

Up.

Still not working. Don't know if inittab is not executed or if there is an error.
Perhaps I can see it in a log file ? But witch one ?

przytula_guy · #9 (**permalink**) 08-08-11, 02:47

should be in startup message in system log /var/log/message

tweetysat · #10 (**permalink**) 08-08-11, 02:52

/var/log/message does not exists ...

przytula_guy · #11 (**permalink**) 08-08-11, 03:01

have a closer look /var/log/messages (typo error - ls would have revealed..)
I understand making an entry in forum is easier than having a look at the system..

tweetysat · #12 (**permalink**) 08-08-11, 03:11

Even with a closer look, no /var/log/message and no /var/log/messages.
I understand that you think that I think it's easier to add a post on a forum than making a simple ls command ... but I did the ls command and don't waited for you to tell me ...

przytula_guy · #13 (**permalink**) 08-08-11, 03:45

according the ubuntu doc :
Switch to VT4 or view the contents of /var/log/syslog (use nano as editor) to check for any specific error messages. After that, also check the output of dmesg.

tweetysat · #14 (**permalink**) 08-08-11, 03:57

Ok, so ...

I found how to 'reactivate' /var/log/messages (deactivated under ubuntu because redundant with other log files).
But no trace of any db2 message in messages,syslog and dmesg.

przytula_guy · #15 (**permalink**) 08-08-11, 04:14

so....
this is the challenge - pd/psi
and this means : problem determiniation / problem source identification...

Internet Services

Web Development

Digital Marketing

Consumer Tech