IBM Support

SQL30082N Security processing failed with reason code 42 "ROOT CAPABILITY REQUIRED" received for a root installation of DB2.



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.

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>".

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Install\/Migrate\/Upgrade - Fixpak","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"10.1;10.5;9.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018