Prev: Help SQL
Next: How to convert nonpartitioned indexes in DB2 V9.7.1
From: Kiram on 3 Mar 2010 18:42
Hi,

I get different results when I try to find the fenced user id of the
instance and I need some help determining the right one so that I can
upgrade the instance in the right way. I am v8 fixpack 11 so I cannot
run db2pd -fmp.

Here are my results.

db2inst1(a)rtcc101 $ cat ~/sqllib/ctrl/.fencedID
db2fenc2
===> /home/db2inst1
db2inst1(a)rtcc101 $ ls -l ~/sqllib/adm/.fenced
-r--r--r-- 1 db2inst1 db2fgrp2 0 2007-11-13 20:29 /home/db2inst1/
sqllib/adm/.fenced
===> /home/db2inst1
db2inst1(a)rtcc101 $ ps -ef|grep db2fmp
db2inst1 8136 6845 0 Feb02 ? 00:05:42 db2fmp ,
1,0,0,0,0,0,0,578014,2,0,1,587fc0,0x210000000,0x210000000,1254c000,30005,2,b3014f
db2fence 8194 7019 0 Feb02 ? 00:00:21 db2fmp ,
1,0,0,0,0,0,0,1e014,2,0,1,29fe0,0x212d4000,0x212d4000,15fc000,50009,2,bd8154
db2inst1 8343 7362 0 Feb02 ? 00:00:59 db2fmp ,
1,0,0,0,0,0,0,200014,2,0,1,20ffc0,0x210000000,0x210000000,dee8000,7800e,
2,cd0169
db2inst3 14964 7806 0 Feb02 ? 00:00:34 db2fmp ,
1,0,0,0,0,0,0,1e014,2,0,1,29fc0,0x210000000,0x210000000,2724000,98012,2,21901af
db2fence 11600 7019 0 Feb03 ? 00:00:00 db2fmp ,
0,0,0,0,0,0,0,1e014,2,0,1,89fe0,0x212d4000,0x212d4000,15fc000,50009,2,2a53024c
db2inst1 7136 6845 0 Feb07 ? 00:00:00 db2fmp ,
0,0,0,0,0,0,0,578014,2,0,1,15fbfc0,0x210000000,0x210000000,1254c000,30005,2,623d0225
db2inst1 15867 7362 0 Feb08 ? 00:00:00 db2fmp ,
0,0,0,0,0,0,0,200014,2,0,1,81bfc0,0x210000000,0x210000000,dee8000,7800e,
2,16378279
db2inst1 13378 6845 0 Feb16 ? 00:00:00 db2fmp ,
0,0,0,0,0,0,0,578014,2,0,1,266ffc0,0x210000000,0x210000000,1254c000,30005,2,486d826e
db2inst1 23296 23135 0 18:29 pts/0 00:00:00 grep db2fmp
===> /home/db2inst1
db2inst1(a)rtcc101 $ ps -ef|grep 6845
db2inst1 6845 6844 0 Feb02 ? 00:00:00 db2sysc 0
db2inst1 6846 6845 0 Feb02 ? 00:01:41 db2gds 0
db2inst1 6847 6845 0 Feb02 ? 00:01:21 db2ipccm 0
db2inst1 6848 6845 0 Feb02 ? 00:02:04 db2tcpcm 0
db2inst1 6849 6845 0 Feb02 ? 00:02:04 db2tcpcm 0
db2inst1 6855 6845 0 Feb02 ? 00:00:00 db2resync 0
db2inst1 6858 6845 0 Feb02 ? 00:00:05 db2hmon ,
0,0,0,1,0,0,0,578014,2,0,1,bfc0,0x210000000,0x210000000,1254c000,30005,2,a0013
db2inst1 8136 6845 0 Feb02 ? 00:05:42 db2fmp ,
1,0,0,0,0,0,0,578014,2,0,1,587fc0,0x210000000,0x210000000,1254c000,30005,2,b3014f
db2inst1 7136 6845 0 Feb07 ? 00:00:00 db2fmp ,
0,0,0,0,0,0,0,578014,2,0,1,15fbfc0,0x210000000,0x210000000,1254c000,30005,2,623d0225
db2inst1 13378 6845 0 Feb16 ? 00:00:00 db2fmp ,
0,0,0,0,0,0,0,578014,2,0,1,266ffc0,0x210000000,0x210000000,1254c000,30005,2,486d826e
db2inst1 23361 23135 0 18:30 pts/0 00:00:00 grep 6845
=

1st method says db2fenc2 is the fenced user id.

2nd and 3rd method says db2inst1 which is the instance owner itself is
the fenced user id.

Which one is the right one.

Let me know so that I need to run the db2iupgrade command as root to
upgrade to v9.7 fixpack 1
 | 
Pages: 1
Prev: Help SQL
Next: How to convert nonpartitioned indexes in DB2 V9.7.1