next generation technology utility benchmarks
TRANSCRIPT
1
—
Next Generation Technology Utility Benchmarks – Presented by Gothaer Systems –IDUG EMEA 2015
2Internal Use Only
Next Generation Performance for the Digital Age
Modern databases require Next Generation Technology• No external SORT
• Reduced resources• No need to decompress
• Increased speed
• Massive Usage of zIIPs
• Performance• Adaptable parallelism to handle extremely large objects
• Planned future improvements in existing products with integration of the new technology
• True Adaptable Automation
3Internal Use Only
Next Generation Technology Data Management
Scalability
Cognitive Autonomics
Resiliency
Full Availability
Performance
4
—
Customer Benchmarks
5
0
5
10
15
20
25
IBM Classic BMC NGT
REORG - Segmented TS – Segsize 32 – 2 IXs 53 M Rows –1.74M Pages
Elapsed time 53% Faster than IBM
with NGT
Elapsed time in Minutes
6
0
50
100
150
200
250
300
350
IBM Classic BMC NGT
REORG - Segmented TS – Segsize 32 – 2 IXs 53 M Rows –1.74 M Pages
CPU time 64% Less than IBM with
NGT
CPU time in Seconds
70
10
20
30
40
50
60
70
IBM Classic BMC NGT
REORG - Segmented TS – Segsize 64 – 1IX 54 Million Rows – 6.785M Pages
NGT – 37% savings over IBM
Elapsed time in Minutes
80
100
200
300
400
500
600
700
IBM Classic BMC NGT
REORG - Segmented TS – Segsize 64 – 1IX 54 Million Rows – 6.785M Pages
NGT – 74% savings over IBM
CPU time in Seconds
90
0.5
1
1.5
2
2.5
3
3.5
4
4.5
IBM Classic BMC NGT
REORG - Partitioned TS – 8 Partitions – 9IX 17 Million Rows – 596,000 Pages
NGT – 49% savings over IBM
Elapsed time in Minutes
10
REORG - Partitioned TS – 8 Partitions – 9IX 17 Million Rows – 596,000 Pages
NGT – 60% reduction in CPU
over IBM
CPU time in Seconds
0
50
100
150
200
250
IBM Classic BMC NGT
110
5
10
15
20
25
30
IBM Classic BMC NGT
REORG – PBG TS – Segsize 32 – 1IX 149 Million Rows –1.863M Pages
NGT – 65% faster than IBM
Elapsed time in Minutes
120
100
200
300
400
500
600
IBM Classic BMC NGT
REORG – PBG TS – Segsize 32 – 1IX 149 Million Rows –1.863M Pages
NGT – 42% less CPU than IBM
CPU time in Seconds
130
50
100
150
200
250
300
IBM NGT
REORG – Partitioned TS – 60 Parts– 16IX 617 Million Rows – 31.4M Pages
NGT – 1 hour faster than IBM!
Elapsed time in Minutes
140
2000
4000
6000
8000
10000
12000
14000
16000
18000
20000
IBM NGT
REORG – Partitioned TS – 60 Parts– 16IX 617 Million Rows – 31.4M Pages
NGT – Saved 1 hour and 40 minutes of CPU time and reorganized and validated all 16
indexes!
CPU time in Seconds
15
0
5
10
15
20
25
30
IBM Classic BMC NGT
UNLOAD – Partitioned TS – 8 Parts– 612 Million Rows –4M Pages
NGT reduced elapsed time by 56% over IBM
Elapsed time in Minutes
16
0
100
200
300
400
500
600
700
800
900
IBM Classic BMC NGT
UNLOAD – Partitioned TS – 8 Parts– 612 Million Rows –4M Pages
NGT reduced CPU time by 88% over IBM
CPU time in SecondsIBM automatically
cancelled by JES after 800 CPU seconds! Only
87% complete!
17
0.00
0.50
1.00
1.50
2.00
2.50
3.00
3.50
4.00
4.50
IBM NGT
UNLOAD – Partitioned TS – 9 IXs – 17 Million Rows –596,000 Pages
NGT reduced Elapsed time by 20% over IBM
Elapsed time in Minutes
18
0
20
40
60
80
100
120
140
IBM NGT
UNLOAD – Partitioned TS – 9 IXs – 17 Million Rows –596,000 Pages
NGT reduced CPU time by 81% over IBM
CPU time in Seconds
190
2
4
6
8
10
12
14
16
18
20
IBM NGT
NGT reduced Elapsed time by 18% over IBM
Elapsed time in Minutes
UNLOAD – PBG TS – Segsize 32 – 1IX 149 Million Rows –1.863M Pages
200
100
200
300
400
500
600
IBM NGT
NGT reduced CPU time by 72% over IBM
CPU time in Seconds
UNLOAD – PBG TS – Segsize 32 – 1IX 149 Million Rows –1.863M Pages
210
5
10
15
20
25
30
35
40
45
50
IBM NGT
NGT reduced Elapsed time by 88% over IBM
Elapsed time in Minutes
LOAD – Partitioned TS – 8 Parts– 612 Million Rows – 4M Pages
220
100
200
300
400
500
600
700
800
900
IBM NGT
NGT reduced CPU time by 19% over IBM
CPU time in Seconds
LOAD – Partitioned TS – 8 Parts– 612 Million Rows – 4M Pages
230
5
10
15
20
25
IBM NGT
NGT reduced Elapsed time by 53% over IBM
Elapsed time in Minutes
LOAD - Segmented TS – Segsize 64 – 1IX 54 Million Rows – 6.785M Pages
240
100
200
300
400
500
600
700
800
900
1000
IBM NGT
NGT reduced Elapsed time by 44% over IBM
CPU time in Seconds
LOAD - Segmented TS – Segsize 64 – 1IX 54 Million Rows – 6.785M Pages
250
2
4
6
8
10
12
14
16
18
IBM NGT
NGT reduced Elapsed time by 59% over IBM
Elapsed time in Minutes
LOAD – PBG TS – Segsize 32 – 1IX 149 Million Rows –1.863M Pages
260
100
200
300
400
500
600
IBM NGT
NGT reduced CPU time by 45% over IBM
CPU time in Seconds
LOAD – PBG TS – Segsize 32 – 1IX 149 Million Rows –1.863M Pages
27
So What?
NGT utilizes sophisticated new architecture to provide full application availability while automating the optimization of application performance, regardless of the complexity or size of the data.
This is a game changer!
BMC is revolutionizing the meaning of
data management for DB2 to meet
the demands of digital business!
28
Lower overall cost of ownership of your z Systems™
Autonomic data management following every rule of the company
Data management designed around the way our customers do business
Applications maintain peak performance at all times
Server Technology for superior throughput. A handful of jobs replaces the customer’s entire utility process.
Other companies have basic utilities. Only BMC has Next Generation Technology Data Management Solutions!
This is a game changer!