Toad World® Forums

Executing Transactions in parallel - DB2 UDB


#1

Dear Group,

I have multiple transactions each made of one to many statements. I would like to run these separate transactions concurrently using different userloads.

ex.

Tran-1:

select * from table-1;

Tran-2:

insert into temp_table-1 select x,y, sum(amt) from table-1;
select * from temp_table-1 ;

Tran-3:

insert into temp_table-1 select x,y, sum(amt) from table-1;
insert into temp_table-2 select a,b, sum(amt) from table-1;
insert into temp_table-2 select w,z, sum(amt) from table-2;
select * from temp_table-1, temp_table-2 … where ;

I would like to run each of these transactions Tran-1, Tran-2, Tran-3 in parallel (concurrently) using 1 user, 5 user , 10 user load etc. The stements within each transaction have to be executed in sequence.

What would be the best way to achieve this ?

Thanks,
Prince