We are having issues connecting the GT Subset UI to our DB2 z/OS database, since the GT Subset UI does not allow us to provide the additional parameters needed for the database connection. As a possible work around, Broadcom Engineering recommended updating the profiles.xml file under %AppData%\Grid-Tools\ folder to include additional parameters inside the <Mechanism> tag.
Since our db2cli.ini uses the following information to connect to the DB2 DSN, which works fine in Datamaker:
I tried applying the same in profiles.xml i.e. <Mechanism>Default</Mechanism> was replaced by
<Mechanism>Security=SSL; SSLClientKeystoredb=C:\Program Files\IBM\IBM DATA SERVER DRIVER\cfg\<<FILE_NAME>>; SSLClientKeyStash=C:\Program Files\IBM\IBM DATA SERVER DRIVER\cfg\<<FILE_NAME>>; CurrentPackageSet=CG1VRMDW;</Mechanism>
FYI: I have attached the profiles.xml to this email, which has passwords stripped.
[jcc][t4][4.21.29] A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001
Release : 4.8
Component : CA Test Data Manager