Neotys.com

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
Answer count
10 answers
Category
NeoLoad Monitoring
Author name
Harısh N.
Date
April 17, 2019
over 5 years ago
Hits
viewed 536 times
question
q

Answers

Neil W.

Neil W.

Level
4
5000 / 5000
points
Team

What does your connection string look like?

Author name
Neil W.
Date
answer
a
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,

Neoload-DB2.xlsx Neoload-DB2.xlsx
Neoload-DB2.xlsx
12.3 KB
April 17, 2019
Processed
Author name
Harısh N.
Date
answer
a
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?

Author name
Neil W.
Date
answer
a
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

Author name
Harısh N.
Date
answer
a
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?

Author name
Nouredine A.
Date
answer
a
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

Author name
Harısh N.
Date
answer
a
Neil W.

Neil W.

Level
4
5000 / 5000
points
Team

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

Author name
Neil W.
Date
answer
a
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>

Author name
Harısh N.
Date
answer
a
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

Author name
Neil W.
Date
answer
a
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.

Author name
Harısh N.
Date
answer
a