I'm receiving an error message on DB2 184.108.40.206 running on AIX 7.1 and authenticating using QAS 4.0.3. If I log in to the database server and try to connect using "db2 connect to databasename user username using password" I get the following error message: SQL30082N Security processing failed with reason "1" ("PASSWORD EXPIRED").
SQLSTATE=08001. If I try to connect using "db2 connect to databasename" it works fine. I also get this error message trying to connect through any database utility on my local machine. My DBAUTH is set to OSAUTH and I feel like QAS is authenticating properly since I'm able to log into the server. Any ideas?
Is this a new installation of Quest-Authentication-Services with this db2 v220.127.116.11?
Or is it an upgrade?
Try increasing the DIAGLEVEL to 4 for the db2 instance, then repeat the "db2 connect to $dbame user $userid using $password" and see what's in the db2diag.log
If you are able to increase the diagnostic level for the QAS services, then what information do you see there.
You may get better support from Dell (who now owns/supports this software QAS) or Dell forums. IBM does not support QAS.