SQL30082N – ROOT CAPABILITY REQUIRED

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