When trying to create a connection profile in Datamaker for DB2, We received 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
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 installation 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.
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.
Once the IBM related issue has been resolved, follow the directions in this document to continue creating your DB2 connection profile: https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/installing/install-test-data-manager/connect-datamaker-to-test-data-source-and-target-databases.html
If you experience any further issues, please open a support case by going to https://support.broadcom.com.