Prior to installing the DB2 plug-in, users were able to access the database using a local account.
After the DB2 plug-in was installed & configured, database access using either local & AD accounts are denied when using TOAD.
Problem: Unable to access DB2 database with TOAD after installing Centrify DB2 module
Cause: This issue appears to be specific to TOAD. Note: TOAD is a set of development tools used for application development, database development, or business intelligence and assist developers in deploying Oracle-based applications and Web services on the Windows platform.
Background: Prior to installing the DB2 plug-in, users were able to access the database using a local account. After the DB2 plug-in was installed & configured, database access using either local & AD accounts are denied when using TOAD. ERROR [08001] [IBM] SQL30082N Security processing failed with reason "17" ("UNSUPPORTED FUNCTION"). SQLSTATE=08001 Access to the database using IBM Data Studio with either local or AD accounts is successful. This issue appears to be specific to TOAD.
Resolution: Recreate the database catalog in TOAD and specify "Server Encrypt" for the Authentication.
Steps on how to enable encryption on the DB/2 Client setup:
Select the specific Client Alias Launch the “Change Database Wizard” Specify the “Security Options” Select “Server Authentication” \ “Enable Encryption”
Here are two NON Centrify links that provide more information on this issue. https://support.software.dell.com/toad-for-db2-luw/kb/91179 https://danieladeniji.wordpress.com/2010/06/12/db2-configuration-assistant-error-sql30082n-security-processing-failed-with-reason-17-unsupported-function-sqlstate08001/