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 Forums!
  • 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.

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

Root Capability Required error

(OP)
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.

RE: Root Capability Required error

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

RE: Root Capability Required error

(OP)
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.

RE: Root Capability Required error

(OP)
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".

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!

Resources

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