Error SQL30082N Reason Code 15 or 24 or 36
When trying to connect to a database or run any db2 commands I'm receiving one or both of the following errors:
SQL30082N Security processing failed with Reason Code 15
"Security processing at the server failed "
SQL30082N Security processing failed with Reason Code 24
"USERNAME AND/OR PASSWORD INVALID "
SQL30082N Security processing failed with reason "36" ("UNEXPECTED
CLIENT ERROR"). SQLSTATE=08001
The following message may also be seen in the db2diag.log:
secGetGroups failed with rc = -2146499506
Resolving the problem
Perform the following steps to resolve this issue:
1.) Please make sure your user id used to connect to the database is following the naming rules for DB2:
User, user ID and group naming rules
If the user id in question is following the correct naming rules listed above, and the error is still occurring please follow the below steps:
2.) Check the permission's on the following files in the instance ~/sqllib/security/ directory:
ls -l /usr/db2inst1/sqllib/security
-r-s--x--x 1 root db2inst1 20374 Apr 14 2008 db2ckpw*
-r-s--x--x 1 root db2inst1 14387 Apr 14 2008 db2chpw*
3.) Stop the instance by running:
4.) Log in as a user id that has root authority.
5.) Issue the following command to update the instance:
- DB2DIR/instance/db2iupdt InstanceName
DB2DIR/instance directory, where DB2DIR is the location where the current version of the DB2 database product is installed.
InstanceName put the name of your instance you want to update.
6.) Then start the instance by running:
Then try to reproduce the SQL30082 error, if you still see the error please proceed onto the next step:
7.) Make sure the catalog information on the client is correct.
8.) Please try restarting the nscd daemon if you are on Linux or Unix:
The nscd daemon is a caching daemon which is found under the /etc/init.d/. It provides caching services for hosts,passwd,group,ipnodes databases using various nameservice lookups like hosts file, DNS, NIS,NIS+ and more.
To stop and start this demon you must be root:
Stopping nscd: /usr/sbin/nscd: Only root is allowed to use this option! [FAILED]
Ran as root:
Stopping nscd: [ OK ]
Starting nscd: [ OK ]
SQL30082 RC=24 or RC=15 returned when connecting to database on Server when pwd_algorithm is Crypt, MD5, SHA1, SHA256, SHA512, Blowfish
For further discussion on this topic, visit this developerWorks forum thread:
More support for:
DB2 for Linux, UNIX and Windows
OTHER - Uncategorised
Software version: 9.7, 10.1, 10.5, 11.1
Operating system(s): AIX, HP-UX, Linux, Solaris
Software edition: Enterprise Server, Personal, Workgroup Server
Reference #: 1416382
Modified date: 21 July 2016