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

Document ID : KB000005242
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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 

Environment:
CA Test Data Manager (TDM)- Datamaker
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.

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.