Execute a series of concurrent valuations
false
true
CalculateFees
1
=
CalculatePerformanceDetails
1
=
DriverURL
jdbc:jtds:sqlserver:
=
DatabasePort
1433
=
UseMiddleTierValuationEngine
0
=
MiddleTierRequestTimeout
500000
=
PricePropagationMode
2
=
PCOQuality
5
=
ValueDate
2011-07-21
=
ReportingDate
2011-07-21 12:30:08.337
=
Database
HSPAD_MI_440_SSD
=
DatabaseHost
GAIA
=
DatabaseUser
sa
=
DatabasePassword
sa2008
=
Pfo_1
1548
=
Pfo_2
1611
=
Pfo_3
1613
=
CutOff Nr 11249, 2011-07-2 / 2011-07-21 12:30:08.337 / DailyNAV Estimate / Within Price Cut-Off
false
5000
${DriverURL}//${DatabaseHost}:${DatabasePort}/${Database}
net.sourceforge.jtds.jdbc.Driver
true
${DatabasePassword}
25
10000
60000
${DatabaseUser}
4096
Connect to local HSPAD_Demo_CO and set its isolation mode to SNAPSHOT (4096) and disable auto commit.
continue
false
3
3
0
1316530469000
1316530469000
false
WorkBench
Concurrent Valuation Test Plan
PCO Valuation
continue
false
1
1
1
1320821253000
1320821253000
false
1
0
UPDATE T_SettingGlobal SET UseMiddleTierValuationEngine=?, MiddleTierRequestTimeout=?
${UseMiddleTierValuationEngine}, ${MiddleTierRequestTimeout}
BIT, INTEGER
Prepared Update Statement
Commit
1
0
0
Update Statement
DBCC DROPCLEANBUFFERS
Update Statement
DBCC FREEPROCCACHE
true
Update Statement
BEGIN TRAN COMMIT TRAN
false
Callable Statement
PfoVal_Recalculate ?, ?, 1
${Pfo_1}, ${PfoValInstance}
INTEGER, INTEGER
true
groovy
import groovy.sql.Sql import org.apache.jmeter.protocol.jdbc.config.DataSourceElement try { // build Pfo List println("Building Portfolio List") def pfoList = "<PfoList>" def pfoNr = 1 def pfo = vars.get("Pfo_" + pfoNr) while(pfo != null) { println("Pfo: $pfo"); pfoList = pfoList + "<Pfo ID='$pfo' EmptyValuation='true' PropagatePrice='true'/>" pfoNr++ pfo = vars.get("Pfo_" + pfoNr) } pfoList = pfoList + "</PfoList>" vars.put("PfoListXML", pfoList) } catch (Exception e) { println(e.toString()); }
CreatePriceCutOff ?, ?, ?, ?, ?, ?, ?, ?
${__threadNum},${ValueDate},${PCOQuality},${ReportingDate},]NULL[,${PCO},${PfoListXML},${PricePropagationMode}
VARCHAR, DATE, INTEGER,TIMESTAMP,INTEGER,OUT INTEGER,CLOB,INTEGER
Callable Statement
Prepared Select Statement
select Nr from PfoValInstance where Pfo=? AND PriceCutOff=?
${Pfo_1},${PCO}
INTEGER,INTEGER
PfoValInstance
DeletePriceCutOff ?
${PCO}
INTEGER
Callable Statement
${JMeterThread.last_sample_ok}
false
Commit
Commit the transaction of the valuation
false
${JMeterThread.last_sample_ok}==false
false
Rollback
false
false
saveConfig
true
false
true
false
true
false
false
true
false
false
false
false
false
false
true
false
false
false
false
false
0
false
saveConfig
true
true
true
true
true
true
true
true
true
false
true
true
false
false
true
false
false
false
false
false
0
true
false
saveConfig
true
true
true
true
true
true
true
true
true
false
true
true
false
false
true
false
false
false
false
false
0
true