Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Root Capability Required error

Goodz13 (Programmer) (OP)
4 Dec 07 13:55
Hello,

I'm getting a strange error when trying to connect to db2 v9.5 express c on Linux.

The error I'm getting is:

DB2 SQL Error: SQLCODE=-30082, SQLSTATE=08001, SQLERRMC=42;ROOT CAPABILITY REQUIRED;, DRIVER=3.50.109DSRA0010E: SQL State = 08001, Error Code = -30,082.

I did a search and all I have found is that it says that I'm using an invalid user/password, but I'm using the same user/pw that I have always used and I am able to ssh into the server that hosts db2 using that same user password.

Not that the user that I'm using is the same one that installed db2. And I am able to run selects if I connect to my database using the db2 command from the prompt.

Please help.
sathyarams (IS/IT--Management)
4 Dec 07 15:30
How do you connect? JDBC? ODBC ? or ... ?

Any messages in db2diag.log on client or server ?
Set the diaglevel to 4 and capture diag messages to get more info.

Also, try a client trace - cli trace or jdbc trace.

 




For db2 resoruces visit www.db2click.com
More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp

Goodz13 (Programmer) (OP)
5 Dec 07 8:01
We are using JDBC.  Also when we login to the Control Center, it isn't showing any databases, but when we look in the MODE0000 directory, it looks like all the databases are there.

It has something to do with authentication.  We see messages in the logs saying unable to authenticate.  The sysadmin and I were both looking into the issue and we compared this environment with an identical environment and as far as we can tell, both configurations are the same.  The only differences that we can tell is that one environment is working fine and the other suddenly started failing on authentication.
Goodz13 (Programmer) (OP)
5 Dec 07 8:19
I should have waited a few minutes before I posted.  My Sysadmin just came to my desk to tell me that the issue was resolved.  

For some reason the db2ckpwd was running as db2inst1 instead of root.  Which makes sense because if the user is being authenticated at the OS level, root would be the only user that could do that.  Hence the error message "Root Capability Required".
sathyarams (IS/IT--Management)
5 Dec 07 11:33
Thanks for providing an update. I would recommend that you do an db2iupdt on the instance ,just in case there are other permission changes in the environment.

For db2 resoruces visit www.db2click.com
More DB2 questions answered at www.dbforums.com/f8 & http://www.idug.org/user/UserLogin.asp

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close