24 Jul 2009
Hi Rock,
Once you defined logtable,and logon etc, we desribe the parameters :
.BEGIN LOAD
Sessions 10 2
pack 10
robust on/off
serialize on/off
checkpoint say 30
nomonitor
rate 2
errortable Rock_err;
.layout l1;
.field f1 * char(20);
.field f2 * char(20);
.field f3 * char(20);
.dml label dml1;
insert rocktab(f1,f2,f3) values(:f1,:f2,:f3);
.import infile sample.txt layout l1 format text apply dml dml1;
etc etc
Thanks and regards,
Raja
27 Jul 2009
hi ,
Thanks a lot for the script, any idea how can we change the rate dynamically ??
Also, how does it actually control the number of insert/update statements in td ? does it restrict the number of packets of sql statements sent by the parsing engine to the amps.. ?
You must sign in to leave a comment.
Hi All,
We are aware that Tpump gives control over the rate per minute at which statements are sent to the RDBMS. This can be done either dynamically or with a predefined statement in the script.
Can any of you let me know this can be done dynamically ??
Can you give me a sample script of how it has to be defined in the script ? And how exactly this works ?
Rgrds,
Rock