473,802 Members | 2,026 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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_sys tem_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
0x07000000003F8 7D0 : 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 7629
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
2566
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/>"; //open the file echo "<B>Opening file text.txt for writing:</B>"; $fp = fopen('text.txt',w); echo "<BR/>";
1
4312
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. THe program creates a good number of threads. Any suggestions most welcome. Have tried following setting LD_ASSUME_KERNEL=2.2.5 disabling JIT by passing -Djava.compiler=NONE
0
2335
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 "/usr/bin/mysqld_safe --skip-grant-tables &" I show several mysqld procs. and one mysqld_safe, but I can't connect: # ps -aux| grep mysql Warning: bad syntax, perhaps a bogus '-'? See http://procps.sf.net/faq.html root 3650 0.0 0.1 2276 664 ? S ...
0
2161
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 --user switch if running as root /exlibris/sfx_ver/sfx_version_2/app/mysql/libexec/mysqld: ready for connections
4
6009
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 for the "wrapper" was to get the scripts to run with "root" privileges. So far so good. I simply create a "URL shortcut" that some staff can double-click on to initiate the process. However, because I am creating these automated tasks for...
1
5788
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 relevant content of the script: ------------------ #!/bin/bash /usr/lib/postgresql/bin/pg_ctl status -D /var/lib/postgres/data >/dev/null 2>&1 rtn=$?
0
1718
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 address anymore. Anyone can help with the problems highlghted below?
3
1888
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, but when I run it it I get "permission denied". Running it as root gets "address already in use". Here is the code (it's example 2.32); comments are from Lutz, not me: webdir = '.' # where your html files and cgi-bin script directory live
4
8696
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 db2wdog processes each uses +1GB Are these figures normal? Can they be configured? /dg
0
10538
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10285
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9115
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7598
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5494
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5622
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4270
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3792
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2966
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.