Receiving error SQL30082N reason code 42 when Connect to a database via client
Once I've received a complaint from our internal team, that they are unable to connect to the database from the DB2 Client terminal.
Operating System: Windows
DB2 Client Version: V9.7 AESE
Error:
C:\Users\test>db2 connect to sampledb user test1 using test1
SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001
Cause:
Any changes on DB2 files such as db2ckpwd that require root permissions can result in this error message.
Diagnosing the problem:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/c0050516.html
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>".
(OR)
1) cd to sqllib/security
2) run: ls -l
3) Check the permission's on the db2chpw and db2ckpw they should be:
-r-s--x--x 1 root inst1 51195 Dec 1 15:33 db2chpw
-r-s--x--x 1 root inst1 3534773 Dec 1 15:33 db2ckpw
If you need to change the permission's of those files run the following commands (this needs to be done as root, since the files are owned by root):
chmod 4511 db2chpw
chmod 4511 db2ckpw
Stop and restart the instance.
Can you please extend the installation process for DB2 11.5?
ReplyDeleteHi Madhu, sure I'll update a post with 11.5 installation.
DeleteThanks & Regards
Vinay