SQL30082N – ROOT CAPABILITY REQUIRED

19 April,2015 by Jack Vamvas

An application owner reported an error

 

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

 

I checked in the  db2diag.log

 

Password validation for user xxxxx failed with rc = -2146499506

The main reason this sequence of errors appear is due to the DB2 password daemon not started. Therefore the db2sysc process attempts the password check. If the db2sysc process doesn’t have root authority the error code . SQL30082N 42 appears.

How to fix the ROOT CAPABILITY REQUIRED error SQL30082N

 

1)    Check to see  db2ckpwd  is running as Root

2)    If not , start up and restart the db2 instance

Read More on DB2 status checks

DB2 – db2sysc and instance status - DBA DB2

DB2 – verify DB2 is available - DBA DB2 - DBA-DB2.com

Check DB2 instance status - DBA DB2

 

 

 

 

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL30082N – ROOT CAPABILITY REQUIRED

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright