Recently, I was trying to work on IBM DB2 database and establish a connection to this through TDM and I received the below error message. After a lot of research I managed to solve this issue so adding this information here that it can be useful to others.
[IBM][CLI Driver] SQL1031N The database directory cannot be found on the indicated file system. SQLSTATE=58031
It sounds like the error is something to do with the database itself. However, in fact, the resolution for this issue has nothing to do about the database itself. It is related with the client environment that is trying to connect to the DB2 database server.
The following is the scenario when I faced this issue.
Thanks Ken. Just to note that the license is only needed for DB2 z/OS and not if you are running DB2 on LUW.
DB2 Connections seem to be much trickier than others. Don't forget to activate the license on the DB2 client if you see licensing errors. The IBM notes on resolving license issues can be found here: IBM DB2 JDBC driver is not licensed for connectivity by file db2jcc_license_cisuz.jar ERRORCODE=-4472 SQLSTATE=42968 - U…
That's great Taylor. Thank you
I really appreciate you writing this up. I have created a knowledge base article from this so users can see it in our knowledge base as well.
TDM knowledge base: https://support.ca.com/us/product-information/ca-test-data-manager.html?d=t&type=Knowledge?d=t&type=Knowledge
Search for TEC1198559.
I just published it so you may not see it on the site until Oct. 11th.