Unanswered question

Issue in Connecting to DB2 from neolaod

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<

Harısh N.
Harısh N.

Harısh N.

Level
1
289 / 750
points

Answers

Neil W.
Neil W.

Neil W.

Level
4
5000 / 5000
points
Team

What does your connection string look like?

Harısh N.
Harısh N.

Harısh N.

Level
1
289 / 750
points

Hi Neil, I have added a snapshot of what my connection parameters look like from the user path. Please assist. Thanks,

Neil W.
Neil W.

Neil W.

Level
4
5000 / 5000
points
Team

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?

Harısh N.
Harısh N.

Harısh N.

Level
1
289 / 750
points

Hi, Yes, the we tried with port 50000 but again it failed. The driver is 3.69.76

Nouredine A.
Nouredine A.

Nouredine A.

Level
4
5000 / 5000
points
Team

Which DB2 monitor do you use in NeoLoad based on your DB2 version? There are two monitors one specific to version higher than 10.5.

Also did you get the db2jcc.jar and db2jcc4.jar (or db2jcc_license_xx.jar) from your DB2 server?

Harısh N.
Harısh N.

Harısh N.

Level
1
289 / 750
points

yes, I copied the below jar files from DB2 server and pasted into neoload/lib/jdbcDrivers folder
db2jcc4 and db2jcc_license_cu

Neil W.
Neil W.

Neil W.

Level
4
5000 / 5000
points
Team

When you tried port 50000, was it the same error?

Harısh N.
Harısh N.

Harısh N.

Level
1
289 / 750
points

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>

Neil W.
Neil W.

Neil W.

Level
4
5000 / 5000
points
Team

I think we are closer, please remove db2jcc_license_cu.jar and restart Neoload. My working setup only has db2jcc4.jar

Harısh N.
Harısh N.

Harısh N.

Level
1
289 / 750
points

Thanks for your immediate attention.
I am still facing the same error post performing the suggested steps.