Connecting to database failed with error SQL30082N reason "42"

Technote (troubleshooting)


You may receive error SQL30082N reason "42" ("ROOT CAPABILITY REQUIRED") when connecting to database.


The following is an example:

$ db2 connect to sample user user1

Enter current password for user1:

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

You may also see the following :
2009-09-30- I1215A437 LEVEL: Warning
PID : 2490422 TID : 2572 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-62
EDUID : 2572 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, bsu security, sqlexLogPluginMessage, probe:20
DATA #1 : String with size, 64 bytes
Password validation for user user1 failed with rc = -2146499506


This is due to the limitations of non-root installations. Server authentication is not enabled for non-root installations.

Resolving the problem

To enable server authentication for non-root installations, do either of the following:

1. Run the db2iupdt command as a root user

# <DB2_PRODUCT_DIR>/instance/db2iupdt <instance_user>

2. Run the db2rfe command as a root user
See "Enabling root-based features in non-root installations with db2rfe" in the Related URL.

Related information

Limitations of non-root installations
Installing a DB2 product as a non-root user
Enabling root-based features in non-root installations

Document information

More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.5, 9.7, 10.1, 10.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:


Modified date:


Translate my page

Content navigation