Table of Contents

Search

  1. Introduction
  2. Samples and Examples
  3. Tools and Utilities
  4. SDK Resources

Benchmark for IBM DB2

Benchmark for IBM DB2

Compare the results of the IBM DB2 database performance test against the following Informatica benchmark for performance tests run on the database machine:
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 : *************************************************************

0 COMMENTS

We’d like to hear from you!