ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Alteryx Server Knowledge Base

Definitive answers from Server experts.

Error: "SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031" when connecting to DB2 z/OS

gtorres8
Alteryx
Alteryx
Created

Environment Details


When trying to connect to DB2 z/OS 12 within the Alteryx Server, the following error message occurs:

 

Connection Error:
ERROR[59031] [IBM] [CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031

 

idea Skyscrapers
 

The ODBC DSN test connects successfully. Also able to connect via CLI Command Prompt successfully.

 

  • Alteryx Server
    • All versions
  • DB2
    • z/OS 12
  • DB2 ODBC
    • 11.01.4040.491+


Cause


DB2 security features are not enabled.



Resolution


Add the Windows user to the DB2ADMNS and DB2USERS groups in the Windows Local Users and Groups.
 

Note

  • Administrator permissions are required to add users to the local Windows groups.
  • If the DB2 security feature is not enabled, run the db2extsec.exe command to enable it. See procedure 1, otherwise skip to procedure 2.

 

Procedure 1

To enable DB2 security feature:

1. Open a command prompt.
2. Run the db2extsec command to update security settings. For example:

 db2extsec -a new computer name\DB2ADMNS -u new computer name\DB2USERS

Click here for more details.


Procedure 2

How to add the Windows user to the DB2ADMNS and DB2USERS groups in the Windows Local Users and Groups:

1. Hold Windows key + R to open the run dialogue window.
2. Type lusrmgr.msc and click OK.
3. Select Local Users and Groups > Groups.
4. Double-click on DB2ADMNS group.

idea Skyscrapers

5. Click Add and enter in the desired Windows user and click OK.
6. Double-click on DB2USERS group.
7. Click Add and enter in the desired Windows user and click OK.
8. Have the Windows user that was added log out of the Windows session and log back in.
9. Connect to DB2 in the Alteryx workflow.