Unexpectedly an attempt to activate or connect to a database is failing with error message for reason "42" ("ROOT CAPABILITY REQUIRED") even though the DB2 installation was performed as root.
Attempts to activate or connect to a database fail with the following message:
SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED")
Any changes on DB2 files such as db2ckpwd that require root permissions can result in this error message.
Diagnosing The Problem
Resolving The Problem
Often a simple update ran against the instance using the db2iupdt command will correct permissions on DB2 files.
As root run the command "db2iupdt <instance name>".
Was this topic helpful?
16 June 2018