Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#17 Statistics do not print properly when run w/ multple threads

open
nobody
Bug (17)
5
2011-10-08
2011-10-08
Michael
No

Tested with datasource_threads and generator_threads configured with 1 and 4 threads in config.xml and received similar output:
6605 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.Address' table.
This table will have 10000 row(s).
Threads: 4, with around 2500 row(s) per thread.
Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)
======
10,000 450.3 KB 5,000 225.2 KB
10,000 450.3 KB 5,000 225.2 KB
16916 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.Address' table completed in: 00:00:10

ran with -q switch
db2inst1@ubuntu-school:~/DG-test/DG/dist$ java -jar DG.jar -q 1 -d ./data/schemas/movie-merged.xml

6802 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.Address' table.
This table will have 10000 row(s).
Threads: 1, with around 10000 row(s) per thread.
Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)
======
400 18.0 KB 80 3.6 KB
809 36.4 KB 80 3.6 KB
1,212 54.6 KB 80 3.6 KB
1,611 72.5 KB 80 3.6 KB
2,004 90.2 KB 80 3.6 KB
2,394 107.7 KB 79 3.6 KB
2,797 125.9 KB 79 3.6 KB
3,205 144.3 KB 80 3.6 KB
3,610 162.5 KB 80 3.6 KB
4,016 180.8 KB 80 3.6 KB

Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)

4,424 199.2 KB 80 3.6 KB
4,830 217.5 KB 80 3.6 KB
5,235 235.8 KB 80 3.6 KB
5,646 254.2 KB 80 3.6 KB
6,051 272.4 KB 80 3.6 KB
6,455 290.7 KB 80 3.6 KB
6,863 309.0 KB 80 3.6 KB
7,271 327.4 KB 80 3.6 KB
7,631 343.6 KB 80 3.6 KB
8,039 361.9 KB 80 3.6 KB

Comm. (stmts) Comm. (size) Commit Rate (stmts/s) Commit Rate (size/s)

8,449 380.4 KB 80 3.6 KB
8,857 398.7 KB 80 3.6 KB
9,265 417.2 KB 80 3.6 KB
9,665 435.2 KB 80 3.6 KB
10,000 450.3 KB 80 3.6 KB
10,000 450.3 KB 80 3.6 KB
137059 [main] INFO com.ibm.dg.DataGenerator - Generating data for 'Movie.Address' table completed in: 00:02:10

Discussion