Prev: remove DB2 Connect Server ?
Next: DB2 taking a long time to start archiving logs
From: db2dude on 2 Sep 2008 17:51
We have a small problem in one of our database hosts in which the
db2ckpwd daemon process runs under the instance owner id instead of
"root".

Due to this, no other id except the instance owner is able to start
the database instance.

I see the following error messages in the diag if a 'db2start' is
attempted by any other id:
=================================================================
2008-09-02-20.46.25.316730+000 E16455936A405 LEVEL: Error (OS)
PID : 2003132 TID : 258 PROC : db2ckpwd 0
INSTANCE: db2ts NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqloEDUPost, probe:10
MESSAGE : ZRC=0x83000001=-2097151999
CALLED : OS, -, unspecified_system_function
OSERR : EPERM (1) "Not owner"

2008-09-02-20.46.25.317521+000 I16456342A393 LEVEL: Severe
PID : 2003132 TID : 258 PROC : db2ckpwd 0
INSTANCE: db2ts NODE : 000
EDUID : 258 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, oper system services, sqlockpw_daemon_main, probe:
120
DATA #2 : Hexdump, 4 bytes
0x07000000003F87D0 : 8300 0001 ....
=================================================================
Output of ps -ef|grep 'db2ckpwd'

db2ts 1208394 1101990 0 20:56:26 - 0:00 db2ckpwd 0
db2ts 1249456 1101990 0 20:56:26 - 0:00 db2ckpwd 0
db2ts 2244740 1101990 0 20:56:26 - 0:00 db2ckpwd 0
=================================================================

This is running on DB2 9.5 FP1 on AIX 5.3.

Any help would be great!

Thanks,
SA

P.S: - The instance owner home directory is NOT mounted using 'nosuid'
since most of the online solutions pointed to that.

From: Darin McBride on 3 Sep 2008 10:46
db2dude wrote:

> We have a small problem in one of our database hosts in which the
> db2ckpwd daemon process runs under the instance owner id instead of
> "root".
>
> Due to this, no other id except the instance owner is able to start
> the database instance.
>
> I see the following error messages in the diag if a 'db2start' is
> attempted by any other id:

Who installed DB2? Was it installed as root, or as db2ts? If root, does a
db2iupdt fix it? If db2ts, have you run the script that enables root
functions (db2rfe)?

From: db2dude on 3 Sep 2008 11:05
On Sep 3, 10:46 am, Darin McBride
<dmcbr...(a)naboo.to.org.no.spam.for.me> wrote:
> db2dude wrote:
> > We have a small problem in one of our database hosts in which the
> > db2ckpwd daemon process runs under the instance owner id instead of
> > "root".
>
> > Due to this, no other id except the instance owner is able to start
> > the database instance.
>
> > I see the following error messages in the diag if a 'db2start' is
> > attempted by any other id:
>
> Who installed DB2?  Was it installed as root, or as db2ts?  If root, does a
> db2iupdt fix it?  If db2ts, have you run the script that enables root
> functions (db2rfe)?

DB2 was installed as root.

This instance was migrated from DB2 V8 FP14 to DB2 V9.5 FP1 and so
db2imigr was run as root.

 | 
Pages: 1
Prev: remove DB2 Connect Server ?
Next: DB2 taking a long time to start archiving logs