IBM Support

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

Troubleshooting


Problem

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.

Symptom

Attempts to activate or connect to a database fail with the following message:


SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED")

Cause

Any changes on DB2 files such as db2ckpwd that require root permissions can result in this error message.

Diagnosing The Problem

Check File permission requirements for the instance and database directories.

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

UID

swg21680886

Page Feedback