Datamaker Fatal Logon error- The database directory cannot be found on the indicated file system

book

Article ID: 5242

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When trying to create a connection profile in Datamaker for DB2, I am receiving the following error message: 


FATAL CA Test Data Manager- Datamaker logon error 
Cannot connect using supplied values. 
Connection: 
Profile: testDB2 
odbc: -1031 
SQLSTATE= 58031 
[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031 

Cause

IBM's support site says this problem is usually caused when connecting to mainframe DB2 from IBM Data Server Driver, even though DB2 Connect license file exists in the license directory of the install path. This error also could mean the system database directory or local database directory could not be found, or the database has not been created or it was not cataloged correctly. It is also possible, but rare, that your installation of IBM data server was corrupted.

Environment

CA Test Data Manager (TDM)- Datamaker

Resolution

We recommend first trying the resolution from IBM in this document: http://www-01.ibm.com/support/docview.wss?uid=swg21635635 

If this does not work, please reach out to your DBA to verify that the database is created with the correct path specification.


Some users resolved the issue by uninstalling and reinstalling the IBM data server client and license file. We recommend working with your DBA to try other resolutions first though.  

Once the IBM related issue has been resolved, follow the directions in this document to continue creating your DB2 connection profile: https://docops.ca.com/ca-test-data-manager/4-4/en/installing/install-ca-test-data-manager/connect-to-test-data-source-and-target-databases 

Additional Information

If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html.