DB2 results

Introduction

Results for running DB2 100GB and 1T tests in different environments.

Environment1, DB2, 100GB Test

Environment description

Parameter	Value
DB2 version	11.5.6
Storage	SSD disk
CPU	8 cores
RAM	16 GB

Load Test

LOAD TIME IN SEC: 4707

Power Test

https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env1.power.100

Throughput Test

Stream No	Values
0	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env1.through.100
1	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result1.env1.through.100
2	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result2.env1.through.100
3	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result3.env1.through.100

Environment 2

Description

Environment description

Parameter	Value
DB2 version	11.5.6
Architecture	LinuxOne - RedHat on Z machine. S390x
Storage	Appropriate
RAM	1.5 T
Cores	66

Load Test, 100GB

LOAD TIME IN SEC: 1620

Power Test, 100GB

https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.evn2.100.power

Throughput Test, 100 GB

Stream no	Result
0	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env2.through.100
1	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result1.env2.through.100
2	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result2.env2.through.100
3	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result3.env2.through.100

Load Test, 1T

LOAD TIME IN SEC: 8432

Power Test, 1T

https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env2.power.1000

Throughput Test, 1T

Stream no	Result
0	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env2.through.1000
1	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result1.env2.through.1000
2	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result2.env2.through.1000
3	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result3.env2.through.1000

Comparison

Comparison, 100 GB Power Test, Z/LinuxOne - X86 commodity

Environment	Table
Environment1, x86 commodity	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env1.power.100
Environment2, Z/LinuxOne	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.evn2.100.power

Comparison, 100 GB Throughput Test, Z/LinuxOne - X86 commodity

x86 commodity hardware, environment 1 (as above)

Stream No	Values
0	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env1.through.100
1	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result1.env1.through.100
2	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result2.env1.through.100
3	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result3.env1.through.100

X/LinuxOne, environment 2 (as above)

Stream No	Values
0	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result0.env2.through.100
1	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result1.env2.through.100
2	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result2.env2.through.100
3	https://github.com/stanislawbartkowski/mytpcds/blob/master/img/db2.result3.env2.through.100

To compare, values for every stream are added. If any stream failed, the whole sum is failed as well.

For instance, environment 1
Streams: query96,83,56,90 = 263+49+452+2301=3065