Jmeter

JDBC
You need to set up a JDBC Connection Configuration.

For db2

The JDBC driver class is: com.ibm.db2.jcc.DB2Driver

The drivers need to be in the folder ~/jmeter/lib
 * db2java.jar
 * db2jcc.jar
 * db2jcc_license.jar

For a SELECT query put you variable in "Variable names".

for example:

Variable names: member_name

If the Response data is:


 * member_name_# = 1
 * member_name_1 = paulkane

IF Controller
To perform a task only if the last task failed use :

Time
Time variable

Math
Long sum