07-20-2015 16:32:02:000 : *********** TestIO Utility version 1.4 **********************
07-20-2015 16:32:02:016 : Number of java threads : 10
07-20-2015 16:32:02:172 : Database Type : DB2
07-20-2015 16:32:02:172 : Host Name : localhost
07-20-2015 16:32:02:172 : Port : 50000
07-20-2015 16:32:02:172 : Database Name : DB2
07-20-2015 16:32:02:172 : User Name : cmx_ors
07-20-2015 16:32:02:172 : Password : **********
07-20-2015 16:32:02:172 : JDBC Url generated : jdbc:db2://localhost:50000/DB2
07-20-2015 16:32:02:172 : Number of records: 60000000
07-20-2015 16:32:02:172 : *************************************************************
07-20-2015 16:32:02:172 : before 10 JDBC connections ....
07-20-2015 16:32:02:640 : after 10 JDBC connrections ....
07-20-2015 16:32:02:640 : JDBC driver version is: 3.64.82
07-20-2015 16:32:02:640 : Temp Table name - c_repos_test_9741
07-20-2015 16:32:02:640 : DML operations are going to be run in multiple threads with thread count = 10
07-20-2015 16:32:02:640 : Start create table and indexes
07-20-2015 16:32:02:655 : CREATE TABLE c_repos_test_9741 ( id int NOT NULL, create_date date, last_update_date date, column1 varchar(255), column2 varchar(255), column3 varchar(255), column4 varchar(255), column5 varchar(255), column6 varchar(255), column7 varchar(255), column8 varchar(255), column9 varchar(255), column10 varchar(255), column11 varchar(255), column12 varchar(255), column13 varchar(255), column14 varchar(255), column15 varchar(255), column16 varchar(255), column17 varchar(255), column18 varchar(255), column19 varchar(255), column20 varchar(255), column21 varchar(255), column22 varchar(255), PRIMARY KEY (id))
07-20-2015 16:32:02:671 : CREATE INDEX c_repos_test_9741_index1 on c_repos_test_9741(column1) cluster
07-20-2015 16:32:02:702 : CREATE INDEX c_repos_test_9741_index2 on c_repos_test_9741(column2, column3, column4)
07-20-2015 16:32:02:702 : Done create table and indexes
07-20-2015 16:32:02:702 : Inserting rows in threads begin....
07-20-2015 16:32:02:702 : Start insert rows through thread number 0
07-20-2015 16:32:02:702 : Start insert rows through thread number 1
07-20-2015 16:32:02:702 : Start insert rows through thread number 2
07-20-2015 16:32:02:702 : Start insert rows through thread number 3
07-20-2015 16:32:02:702 : Start insert rows through thread number 4
07-20-2015 16:32:02:702 : Start insert rows through thread number 5
07-20-2015 16:32:02:702 : Start insert rows through thread number 6
07-20-2015 16:32:02:702 : Start insert rows through thread number 7
07-20-2015 16:32:02:702 : Start insert rows through thread number 8
07-20-2015 16:32:02:702 : Start insert rows through thread number 9
07-20-2015 17:55:37:034 : Done insert rows through thread number 0
07-20-2015 17:56:49:590 : Done insert rows through thread number 1
07-20-2015 17:56:55:783 : Done insert rows through thread number 9
07-20-2015 17:57:06:922 : Done insert rows through thread number 7
07-20-2015 17:58:52:784 : Done insert rows through thread number 4
07-20-2015 17:58:56:871 : Done insert rows through thread number 5
07-20-2015 17:59:11:800 : Done insert rows through thread number 6
07-20-2015 17:59:13:157 : Done insert rows through thread number 2
07-20-2015 17:59:18:290 : Done insert rows through thread number 8
07-20-2015 17:59:32:267 : Done insert rows through thread number 3
07-20-2015 17:59:32:267 : Inserting rows in threads end....
07-20-2015 17:59:32:267 : Updating rows in threads begin....
07-20-2015 17:59:32:267 : Start update rows for non-indexed columns through thread number 1
07-20-2015 17:59:32:267 : Start update rows for non-indexed columns through thread number 0
07-20-2015 17:59:32:267 : Start update rows for non-indexed columns through thread number 2
07-20-2015 17:59:32:267 : Start update rows for non-indexed columns through thread number 3
07-20-2015 17:59:32:267 : Start update rows for non-indexed columns through thread number 4
07-20-2015 17:59:32:267 : Start update rows for non-indexed columns through thread number 5
07-20-2015 17:59:32:283 : Start update rows for non-indexed columns through thread number 6
07-20-2015 17:59:32:283 : Start update rows for non-indexed columns through thread number 7
07-20-2015 17:59:32:283 : Start update rows for non-indexed columns through thread number 8
07-20-2015 17:59:32:283 : Start update rows for non-indexed columns through thread number 9
07-20-2015 17:59:48:070 : Done update rows through thread number 0
07-20-2015 17:59:48:210 : Done update rows through thread number 9
07-20-2015 17:59:48:242 : Done update rows through thread number 1
07-20-2015 17:59:48:351 : Done update rows through thread number 7
07-20-2015 17:59:48:538 : Done update rows through thread number 2
07-20-2015 17:59:48:538 : Done update rows through thread number 5
07-20-2015 17:59:48:585 : Done update rows through thread number 4
07-20-2015 17:59:48:585 : Done update rows through thread number 8
07-20-2015 17:59:48:600 : Done update rows through thread number 6
07-20-2015 17:59:48:616 : Done update rows through thread number 3
07-20-2015 17:59:48:616 : Updating rows in threads end....
07-20-2015 17:59:48:616 : Updating rows in threads begin....
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 0
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 1
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 2
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 3
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 4
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 5
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 6
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 7
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 8
07-20-2015 17:59:48:616 : Start update rows for indexed columns through thread number 9
07-20-2015 18:00:05:199 : Done update rows through thread number 0
07-20-2015 18:00:05:355 : Done update rows through thread number 9
07-20-2015 18:00:05:370 : Done update rows through thread number 1
07-20-2015 18:00:05:433 : Done update rows through thread number 7
07-20-2015 18:00:05:558 : Done update rows through thread number 4
07-20-2015 18:00:05:558 : Done update rows through thread number 5
07-20-2015 18:00:05:573 : Done update rows through thread number 8
07-20-2015 18:00:05:636 : Done update rows through thread number 6
07-20-2015 18:00:05:651 : Done update rows through thread number 2
07-20-2015 18:00:05:667 : Done update rows through thread number 3
07-20-2015 18:00:05:667 : Updating rows in threads end....
07-20-2015 18:00:05:667 : Selecting rows in threads begin....
07-20-2015 18:00:05:667 : Start select rows through thread number 0
07-20-2015 18:00:05:667 : Start select rows through thread number 1
07-20-2015 18:00:05:667 : Start select rows through thread number 2
07-20-2015 18:00:05:667 : Start select rows through thread number 3
07-20-2015 18:00:05:667 : Start select rows through thread number 4
07-20-2015 18:00:05:667 : Start select rows through thread number 5
07-20-2015 18:00:05:667 : Start select rows through thread number 6
07-20-2015 18:00:05:667 : Start select rows through thread number 7
07-20-2015 18:00:05:667 : Start select rows through thread number 8
07-20-2015 18:00:05:667 : Start select rows through thread number 9
07-20-2015 18:01:13:418 : Done select rows through thread number 1
07-20-2015 18:01:17:692 : Done select rows through thread number 6
07-20-2015 18:01:18:878 : Done select rows through thread number 9
07-20-2015 18:01:18:893 : Done select rows through thread number 4
07-20-2015 18:01:19:751 : Done select rows through thread number 3
07-20-2015 18:01:20:141 : Done select rows through thread number 7
07-20-2015 18:01:20:173 : Done select rows through thread number 8
07-20-2015 18:01:20:219 : Done select rows through thread number 5
07-20-2015 18:01:20:703 : Done select rows through thread number 0
07-20-2015 18:01:20:765 : Done select rows through thread number 2
07-20-2015 18:01:20:765 : Selecting rows in threads end....
07-20-2015 18:01:20:765 : Deleting rows in threads begin....
07-20-2015 18:01:20:765 : Start delete rows through thread number 0
07-20-2015 18:01:20:765 : Start delete rows through thread number 1
07-20-2015 18:01:20:765 : Start delete rows through thread number 2
07-20-2015 18:01:20:765 : Start delete rows through thread number 3
07-20-2015 18:01:20:765 : Start delete rows through thread number 4
07-20-2015 18:01:20:765 : Start delete rows through thread number 5
07-20-2015 18:01:20:765 : Start delete rows through thread number 6
07-20-2015 18:01:20:765 : Start delete rows through thread number 7
07-20-2015 18:01:20:765 : Start delete rows through thread number 8
07-20-2015 18:01:20:765 : Start delete rows through thread number 9
07-20-2015 18:01:37:177 : Done delete rows through thread number 1
07-20-2015 18:01:37:192 : Done delete rows through thread number 9
07-20-2015 18:01:37:192 : Done delete rows through thread number 0
07-20-2015 18:01:37:301 : Done delete rows through thread number 4
07-20-2015 18:01:37:301 : Done delete rows through thread number 7
07-20-2015 18:01:37:364 : Done delete rows through thread number 8
07-20-2015 18:01:37:364 : Done delete rows through thread number 6
07-20-2015 18:01:37:379 : Done delete rows through thread number 5
07-20-2015 18:01:37:379 : Done delete rows through thread number 2
07-20-2015 18:01:37:442 : Done delete rows through thread number 3
07-20-2015 18:01:37:442 : Deleting rows in threads end....
07-20-2015 18:01:37:442 : Temp Table2 name - c_repos_test_8259
07-20-2015 18:01:37:442 : Start create table as select and indexes
07-20-2015 18:01:37:442 : CREATE TABLE c_repos_test_8259 as (select * from c_repos_test_9741) definition only
07-20-2015 18:01:37:442 : INSERT INTO c_repos_test_8259 select * from c_repos_test_9741
07-20-2015 18:12:01:240 : ALTER TABLE c_repos_test_8259 ADD CONSTRAINT c_repos_test_8259_id UNIQUE (id)
07-20-2015 18:12:36:028 : CREATE INDEX c_repos_test_8259_index1 on c_repos_test_8259(column1) cluster
07-20-2015 18:13:23:889 : CREATE INDEX c_repos_test_8259_index2 on c_repos_test_8259(column2, column3, column4)
07-20-2015 18:14:49:705 : Done create table as select and indexes
07-20-2015 18:14:49:705 : Start drop table c_repos_test_9741
07-20-2015 18:14:55:336 : Done drop table c_repos_test_9741
07-20-2015 18:14:55:336 : Start drop table c_repos_test_8259
07-20-2015 18:14:55:399 : Done drop table c_repos_test_8259
07-20-2015 18:14:55:399 : ************************** Summary **************************
07-20-2015 18:14:55:399 : All DML operations ran in multiple threads with thread count = 10
07-20-2015 18:14:55:399 : All the timings are in hour:min:second:millisecond
07-20-2015 18:14:55:399 : Total distinct database interactions: 9
07-20-2015 18:14:55:399 : 0- operation type: CREATE, count:1
07-20-2015 18:14:55:399 : 1- operation type: INSERT, count:60000001
07-20-2015 18:14:55:399 : 2- operation type: UPDATE, count:200000
07-20-2015 18:14:55:399 : 3- operation type: UPDATE_INDEX, count:200000
07-20-2015 18:14:55:399 : 4- operation type: SELECT, count:200000
07-20-2015 18:14:55:399 : 5- operation type: DELETE, count:200000
07-20-2015 18:14:55:399 : 6- operation type: CTAS, count:1
07-20-2015 18:14:55:399 : 7- operation type: DROP, count:1
07-20-2015 18:14:55:399 : 8- operation type: DROP, count:1
07-20-2015 18:14:55:399 : Total time for the test: 1:42:52:759.0
07-20-2015 18:14:55:399 : Number of operations: 60800005
07-20-2015 18:14:55:399 : Average time for all operations: 0:0:0:0.10152563309822096
07-20-2015 18:14:55:399 : Average transactions/second for all operations: 9849
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of create operations: 1
07-20-2015 18:14:55:399 : Total time for create operations: 0:0:0:62.0
07-20-2015 18:14:55:399 : Average time for all create operations: 0:0:0:62.0
07-20-2015 18:14:55:399 : Average transactions/second for all create operations: 16
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of create table as select operations: 1
07-20-2015 18:14:55:399 : Total time for create table as select operations: 0:13:12:263.0
07-20-2015 18:14:55:399 : Average time for all create table as select operations: 0:13:12:263.0
07-20-2015 18:14:55:399 : Average transactions/second for all create table as select operations: 0
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of drop operations: 2
07-20-2015 18:14:55:399 : Total time for drop operations: 0:0:5:694.0
07-20-2015 18:14:55:399 : Average time for all drop operations: 0:0:2:847.0
07-20-2015 18:14:55:399 : Average transactions/second for all drop operations: 0
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of insert operations: 60000001
07-20-2015 18:14:55:399 : Total time for insert operations: 1:27:29:565.0
07-20-2015 18:14:55:399 : Average time for all insert operations: 0:0:0:0.08749274854178753
07-20-2015 18:14:55:399 : Average transactions/second for all insert operations: 11429
07-20-2015 18:14:55:399 : Total bytes of data inserted: 1158196632
07-20-2015 18:14:55:399 : Average bytes of data inserted/second (bytes/second): 220627
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of update operations in non-indexed table: 200000
07-20-2015 18:14:55:399 : Total time for update operations in non-indexed table: 0:0:16:349.0
07-20-2015 18:14:55:399 : Average time for all update operations in non-indexed table: 0:0:0:0.081745
07-20-2015 18:14:55:399 : Average transactions/second for all update operations in non-indexed table: 12233
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of update operations in indexed table: 200000
07-20-2015 18:14:55:399 : Total time for update operations in indexed table: 0:0:17:51.0
07-20-2015 18:14:55:399 : Average time for all update operations in indexed table: 0:0:0:0.085255
07-20-2015 18:14:55:399 : Average transactions/second for all update operations in indexed table: 11729
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of select operations: 200000
07-20-2015 18:14:55:399 : Total time for select operations: 0:1:15:98.0
07-20-2015 18:14:55:399 : Average time for all select operations: 0:0:0:0.37549
07-20-2015 18:14:55:399 : Average transactions/second for all select operations: 2663
07-20-2015 18:14:55:399 :
07-20-2015 18:14:55:399 : Number of delete operations: 200000
07-20-2015 18:14:55:399 : Total time for delete operations: 0:0:16:677.0
07-20-2015 18:14:55:399 : Average time for all delete operations: 0:0:0:0.083385
07-20-2015 18:14:55:399 : Average transactions/second for all delete operations: 11992
07-20-2015 18:14:55:399 : *************************************************************
