When trying to pull data from a DB2 database via the Input Data tool, the following error occurs:
Connection Error:
ERROR [08001] [IBM][CLI Driver] SQL30082N Security processing failed with reason "15" ('PROCESSING FAILURE'). SQLSTATE=08001.
- Alteryx Designer
- DB2 ODBC Driver
SQLSTATE = 08001 indicates the client is unable to establish connection due to:
- Permissions issue.
- Firewall issue.
1. Delete the existing DSN for DB2.
2. Re-open Alteryx Designer with the Run As Administrator option.
3. Create a new System DSN for DB2. If the DSN tests OK, re-test pulling data from the Input Data tool.
If the DSN doesn't test OK; reconfigure the Windows firewall on the DB2 server per the IBM KB article.
Additional Information
Appendix of ODBC error codes.
null