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  >

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

12 April,16 at 11:44 AM

 Unable to access DB2 database with TOAD after installing Centrify DB2 module


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.

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. 

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.