Connecting to database failed with error SQL30082N reason "42"

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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
REQUIRED"). SQLSTATE=08001

You may also see the following :
2009-09-30-14.16.10.351814-600 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



Cause

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

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.5, 9.7

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1405360

Modified date:

2011-07-05

Translate my page

Machine Translation

Content navigation