Hi, I am unable to connect to DB2 database from neoload for executing SQLs or monitoring DB. Below error is received in neoload. Please help with a resolution. The required jar files have already been placedin /lib/jdbcDrivers folder
<Status state="ERROR">An error occurred while creating the connection: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][3.69.76] Execution failed due to a distribution protocol error that caused deallocation of the conversation.
A DRDA Data Stream Syntax Error was detected. Reason: 0x2110. ERRORCODE=-4499, SQLSTATE=58009<
The format looks okay however I know DB2 by default uses port 50000, you details show port 51000. Googling the error also returned comments about port number being the likely cause. Please see my example from the help: https://www.neotys.com/documents/doc/neoload/latest/#2741...
Can you confirm the name of the jdbc driver file you copied in?
Hi, Yes, the we tried with port 50000 but again it failed. The driver is 3.69.76
yes, I copied the below jar files from DB2 server and pasted into neoload/lib/jdbcDrivers folder
db2jcc4 and db2jcc_license_cu
When you tried port 50000, was it the same error?
I see below error when I try to execute a script that just has a SQL connection in user path.
<Status state="ERROR">An error occurred while creating the connection: java.sql.SQLException: No suitable driver found for jdbc:db2://abspreprodmfdb-vip.allianz-tr.local:50000/DTTUR93</Status>
I think we are closer, please remove db2jcc_license_cu.jar and restart Neoload. My working setup only has db2jcc4.jar
Thanks for your immediate attention.
I am still facing the same error post performing the suggested steps.
