473,383 Members | 1,815 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

db2ckpwd not running under root

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.

Sep 2 '08 #1
2 7570
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)?

Sep 3 '08 #2
On Sep 3, 10:46*am, Darin McBride
<dmcbr...@naboo.to.org.no.spam.for.mewrote:
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.

Sep 3 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: jn | last post by:
They have a server here that runs PHP as root (which is probably bad). I wrote a test script that tries to create a text file. echo "<B>I'm running as user: " . $_ENV . "</B><BR/><BR/>"; ...
1
by: Adi | last post by:
A java program we have written crashes with IBM JDK 1.3.1 on linux. It works fine on other platforms(Solaris,HPUx). It gets a SIGSERV Signal 11 and crashes just after few minutes after starting up....
0
by: Mark Adams | last post by:
I really need some help with this. MySQL will not start on boot despite everything I've done to make sure that it is set to do so. When I start it as root from a terminal with...
0
by: David M. | last post by:
I started the mysql database with the "safe_mysqld" command and with the user who own mysql. in the errr-log file, I have that: 050123 23:16:50 mysqld started Warning: One can only use the...
4
by: Nick Sinclair | last post by:
Hi all, I'm new to C. I have successfully written a small C program that acts as a "wrapper" around cgi scripts. These scripts perform admin tasks such as backing up etc. Obviously, The need...
1
by: Ennio-Sr | last post by:
Hi all! Testing a script where I need to make sure that postgresql is running before passing a <psql dbasename -c "insert into ..." > instruction I faced this curious behaviour: This is the...
0
by: paulhjwu | last post by:
Hi, I have problems running a couple of shell scripts from PHP. I found a similar posting, so I posted my question to the original author. But unfortunately the original author is not at the...
3
by: chernevik | last post by:
Here is a newbie question: how do I get the server examples in the Preview chapter of "Progamming Python" (Lutz) to run? The code is supposed to be a little webserver on which to run examples,...
4
by: danfan46 | last post by:
Hi! I'm on Linux RHEL 64-bit db2 version 9.5.0.1 using four partitions on a single server. The db2ckpwd 4*3 =12 processes each uses 959220 k of memory which totals +10GB. Also the four...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.