Centrify

Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-5877:Unable to access DB2 database with TOAD after installing Centrify DB2 module

12 April,16 at 11:44 AM

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/ 

 

Related Articles

 articleHOWTO: Install, configure and test the Centrify IBM DB2 SSO Module articleHOWTO: Configure DB2 on Linux to leverage Centrify/AD (PAM stack) articleKB-6191: Centrify DB2 plug-in compatibility with DB2 10.5.x version articleKB-20210: Common Questions Regarding Centrify DirectControl and CoreOS articleInstalling DB2 Express-C on Linux and configuring the Centrify DB2 plugin articleKB-3040: How to run setupdb2.sh to configure Centrify DB2 plugin articleHOWTO: Configure the IBM DB2 SSO Module for Kerberos/GSSAPI SSO articleKB-1956: SQL30082N Security processing failed with reason "15" ("Processing Failure"). articleTesting and Troubleshooting Centrify's DB2 plugin