IBM ^ p655 with DB2 UDB 8.1 Total System Cost
TPC-H Rev. 2.1.0 Report Date: Dec. 8, 2003
Composite Query per Hour Rating
Price/Performance
20,221.0
69
QphH@1000GB
$/QphH@1000GB
$1,403,446 Database Size
Database Manager
Operating System
Other Software
Availability Date
1000GB
DB2 UDB 8.1
AIX 5L V5.2
none
June 8, 2004
133.8 RF1
1609.1 Throughput
RF2 1
Power
2
Arithmetic Mean
3
Geometric Mean
4 5 6 7 8 9 10 11 12 13 14 15a 16 17 18 19 20 21
6500
6000
5500
5000
4500
4000
3500
3000
2500
2000
1500
1000
500
0
22
Seconds
Database Load Time: 3:56:39 Load included backup: N Total Data Storage/Database Size: 7.01 RAID (base tables): N RAID (Base Tables and Auxiliary Data Structures): N RAID (All): Y System Configuration 4 IBM ^ p655 servers, each server with 4 x 1700MHz POWER4+ with 128MB L3 Cache Processors 32GB Memory 8 x 2 Gigabit Fibre Channel PCI-X Adapter Disk Controllers 48x 36.4GB 15K 2Gb FC drives – 2x 36.4 GB 10K Ultra3 SCI drivers with 2 additional on node1 Disk Drives 1 IBM Gigabit Ethernet-SX PCI-X Adapter Network 7,012.18GB (GB is defined as 1024 * 1024 * 1024 bytes) Total Disk Storage
IBM ^ p655 with DB2 UDB 8.1 Part Num ber Description Source Server Hardw are 7039-651pSeries 655 Model 651 CEC 1 3168 RIO-2 (Remote I/O-2) Cable, 2.5M 1 3273 36.4 GB 10,000 RPM Ultra3 SCSI Disk Drive Assembly 1 4458 16GB Memory Card 1 5518 4-Way 1.7GHz POWER4+ Processor, 128MB L3 Cache and System 1 3800 Pow er Cable Group, Left, Draw er Position #4609 1 3800 Pow er Cable Group, Left, Draw er Position #4619 1 5700 IBM Gigabit Ethernet-SX PCI-X Adapter 1 6199 DC Pow er Converter Assembly, CEC 1 6430 Pluggable Service Processor 1 6569 ULTRA320 SCSI Backplane, tw o position 1 6591 Dual CEC side by side Mounting Enclosure 1 8121 Attachment Cable, Hardw are Management Console to Host, 15-Me 1 7040-61DI/O Draw er 1:Model 61D I/O Draw er 1 2456 LC-SC 50 Micron Fibre Converter Cable 1 3146 RIO-2 (Remote I/O-2) Cable, 1.2M 1 3801 Pow er Cable Group, Left, Draw er Position #4605 1 3811 Pow er Cable Group, Right, Draw er Position #4605 1 3802 Pow er Cable Group, Left, Draw er Position #4605 1 3812 Pow er Cable Group, Right, Draw er Position #4605 1 3805 Pow er Cable Group, Left, Draw er Position #4627 1 3815 Pow er Cable Group, Right, Draw er Position #4627 1 3804 Pow er Cable Group, Left, Draw er Position #4623 1 3814 Pow er Cable Group, Right, Draw er Position #4623 1 6172 Pow er Converter Assembly, I/O Draw er 1 6239 2 Gigabit Fibre Channel PCI-X Adapter 1 6564 Ultra3 SCSI 4-Pack Hot Sw ap Back Plane 1 6571 I/O Draw er PCI-X Planar, 10 Slot, 2 Integrated Ultra3 SCSI Ports 1 7040-W42MODEL W42 RACK 1 6076 Front Door, Black w ith Copper Accent, Primary Rack 1 6078 Rear Door, Slim Line, Primary Rack 1 6186 Bulk Pow er Regulator 1 1 6187 Pow er Controller, Four Cooling Fans, Three DC Pow er Converter C 6188 Pow er Distribution Assembly 1 8123 Attachment Cables, Hardw are Management Console to 7040-W42, 1 8688 Line Cord, 6AWG/Type W, 14ft, IEC309 60A Plug 1 8690 Bulk Pow er Assembly, Redundant 1 1 7315-C02 Hardw are Management Console, mouse, keyboard, monitor, cables Server Subtotal Storage 7014-T42 System Rack Model T42 (6081,6098) 1 7176 Additional Pow er Distribution Unit 1 1740-1RUIBM FAStT EXP700 Expansion Unit 1 2210 (19K1271) 2Gb Fibre Channel Short Wave GBIC 1 5212 (06P5772) 2Gb FC, 36.4GB/15K Drive 1 1742-90UTotalStorage FAStT900 Storage Server 1 2210 (19K1271) 2 Gbps Fibre Channel Short Wave GBIC 1 3507 (19K1269) FAStT 2 Gbps miniHUB (LC) 1 5605 (19K1248) Fiber Cable 5m Multimode (LC-LC) 1 5702 (19K1250) LC-SC Fibre Channel Adapter Cable 1 DASD Storage Subtotal RACK Hardw are Subtotal
TPC-H Rev. 2.1.0 Report Date: Dec. 8, 2003
Unit Price
Qty
Ext Price
3 Yr Maint.
9,440 400 1,540 23,600 19,755 75 75 1,700 3,500 5,000 350 450 75 3,980 100 500 75 75 75 75 75 75 75 75 4,000 3,100 500 8,000 2,000 3,000 750 4,000 1,900 3,500 275 1,500 5,000 5,586
4 8 10 8 4 2 2 4 4 4 4 4 4 4 4 12 1 1 1 1 1 1 1 1 8 32 16 8 1 1 1 6 2 2 1 2 1 1
37,760 3,200 15,400 188,800 79,020 150 150 6,800 14,000 20,000 1,400 1,800 300 15,920 400 6,000 75 75 75 75 75 75 75 75 32,000 99,200 8,000 64,000 2,000 3,000 750 24,000 3,800 7,000 275 3,000 5,000 5,586 649,311
7,968 0 0 0 15,552 0 0 0 0 0 0 0 0 16,320 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8,400 0 0 0 0 0 0 0 0 696 48,936
3,970 1,200 6,000 499
2 6 16 32 192 8 64 32 32 32
7,940 7,200 96,000 15,968 214,080 532,000 31,936 28,768 4,128 6,368 929,248 15,140
1,776 0 23,040 0 0 16,480 0 0 0 0 41,296
1,115 66,500 499 899 129 199
IBM ^ p655 with DB2 UDB 8.1 Softw are 5765-E62 AIX 5.2 (Media only) 5771-SPTAIX SW SUPPORT 1YR 5771-SUBAIX SW SUB 1YR 5631-SB1 HMC Softw are SUB 5631-ST1 HMC Softw are Support D5A1DLL AIX C Compiler (E1A1FLL) D518GLL E00BILL D518JLL E00BJLL
1 1 1 1 1 1 1 1 1 1
DB2 UDB ESE License/1-yr. Maint. DB2 UDB ESE Support 1Yr/Proc DB2 UDB ESE DPF License/1-yr. Maint. DB2 UDB ESE DPF Support 1Yr/Proc Softw are Subtotal
Third Party Hardw are CDW486569CISCO SFP 'GLC-SX-MM CDW151924Cisco SMARTnet Onsite 1 Year 24x7 4 Hour CDW52826 Cisco Catalyst 3750G-12S (WS-C3750G-12S-S) Third Party Hardw are Subtotal
2 2 2
TPC-H Rev. 2.1.0 Report Date: Dec. 8, 2003
50 708 200 275 525 539 20,451 974 6,143 293 Subtotal
1 48 48 3 3 1 16 32 16 32
399 1,300 5,867
4 3 1
50 0 9,600 825 0 539 327,216
31,168 98,288 436,518
Subtotal
All IBM hardw are & AIX one time volume Discount Storage Service Discount Server Service Discount
5,867 7,463
0 3,900 0 3,900
2,037,680
170,339 2,208,019
1,604,713 0.47
47% 40% 40%
Total Notes (Source): 1. IBM 2. CDW.com w eb pricing
9,376 76,207
1,596
Total Discounts
33,984 0 0 1,575 104
3 Year Cost of Ow nership QphH @ 1000 GB $/QphH @ 1000 GB
(754,215) (16,518) (33,840) (804,573) $ $
1,403,446 1,403,446 20,221 69.41
For assistance w ith any of these prices or their applicability to any customer's requirements, please contact one of the follow ing: Frederick C. Bothw ell, eServer pSeries Offering Manager, email: fbothw
[email protected], phone 1-512-838-6594 Paul Rivot, Director Database Servers and Business Intelligence Softw are, email:
[email protected], phone 1-914-766-1325
Audited by: Francois Raab of Infosizing (www.infosizing.com) The system as configured for the test will be available June 8, 2004 Prices used in TPC benchmarks reflect the actual prices a customer would pay for a one-time purchase of the stated components. Individually negotiated discounts are not permitted. Special prices base on assumptions about past or future purchases are not permitted. All discounts reflect standard pricing policies for the listed components. For complete details see the pricing sections of the TPC benchmark specifications. If you find the stated prices are not available according to these terms, please notify the TPC at
[email protected]. Thank You.
IBM ^ p655 with DB2 UDB 8.1
TPC-H Rev. 2.1.0 Report Date: Dec. 8, 2003
Numerical Quantities Summary Measurement Results: Database Scaling (SF/Size) Total Data Storage/Database Size Start of Database Load End of Database Load Database Load Time Query Streams for Throughput Test TPC-H Power Metric (QppH@1000GB) TPC-H Throughput Metric (QthH@1000GB) Composite Query-per-Hour Rating (QphH@1000GB) Total System Price over 3 years TPC-H Price/Performance Metric ($/QphH@1000GB)
= = = = = = = = = = =
1000 7.01 11/23/2003 15:51:08 11/23/2003 19:47:47 3:56:39 7 26,905.9 15,197.1 20,221.0 $1,403,446 69
Measurement Intervals Measurement Interval in Throughput Test (Ts) = 36,481 seconds Duration of Stream Execution Stream Id Stream 00 Stream 01 Stream 02 Stream 03 Stream 04 Stream 05 Stream 06 Stream 07 Refresh
Seed Used 1123194747 1123194748 1123194749 1123194750 1123194751 1123194752 1123194753 1123194754
Start Date & Time 11/24/2003 09:37:06 11/24/2003 11:02:58 11/24/2003 11:02:58 11/24/2003 11:02:58 11/24/2003 11:02:58 11/24/2003 11:02:58 11/24/2003 11:02:58 11/24/2003 11:02:59 11/24/2003 11:02:59
End Date & Time 11/24/2003 11:01:20 11/24/2003 20:56:07 11/24/2003 20:48:10 11/24/2003 20:53:51 11/24/2003 20:53:12 11/24/2003 20:51:17 11/24/2003 20:52:02 11/24/2003 20:56:17 11/24/2003 21:10:59
Duration 1:24:14 9:53:09 9:45:13 9:50:53 9:50:14 9:48:19 9:49:04 9:53:18 10:08:01
IBM ^ p655 with DB2 UDB 8.1
TPC-H Rev. 2.1.0 Report Date: Dec. 8, 2003
Timing Intervals (in Seconds) Stream ID
Q1
Q2
Q3
Q4
Q5
Q6
Q7
Q8
Q9
Q10
Q11
Q12
Stream 0
292.0
43.4
66.7
37.8
187.6
29.6
233.4
158.5
726.1
159.2
39.1
49.6
Stream 01 Stream 02 Stream 03 Stream 04 Stream 05 Stream 06 Stream 07
1888.3 2174.2 1976.6 2296.6 2225.1 2104.7 2593.5
244.1 197.3 221.2 129.8 150.4 299.4 174.2
500.6 558.6 304.7 477.7 544.6 530.4 493.3
76.6 254.7 244.3 282.8 293.1 284.8 288.2
1159.3 1375.4 1161.8 1362.3 1247.0 1229.5 1175.7
156.0 213.5 144.6 166.4 168.4 143.7 156.4
1802.7 1540.9 1569.9 1749.3 1582.5 1667.8 1616.2
1795.7 1370.9 1399.7 1291.5 1235.5 1109.5 1237.1
5484.4 5157.3 5723.5 5938.6 5618.8 5686.3 5782.9
1070.9 1115.8 1140.5 1124.1 1090.5 1160.3 1260.9
296.9 326.9 319.7 312.6 264.2 314.3 289.1
446.1 431.2 343.7 414.9 374.0 384.8 99.1
Minimum Average Maximum
1888.3 2179.9 2593.5
129.8 202.3 299.4
304.7 487.1 558.6
76.6 246.4 293.1
1159.3 1244.4 1375.4
143.7 164.1 213.5
1540.9 1647.0 1802.7
1109.5 1348.6 1795.7
5157.3 5627.4 5938.6
1070.9 1137.6 1260.9
264.2 303.4 326.9
99.1 356.3 446.1
Stream ID
Q13
Q14
Q15a
Q16
Q17
Q18
Q19
Q20
Q21
Q22
RF1
RF2
Stream 0
428.1
42.3
134.1
197.5
171.9
782.0
186.6
73.3
735.1
214.0
66.7
79.0
Stream 01 Stream 02 Stream 03 Stream 04 Stream 05 Stream 06 Stream 07
2607.7 2672.2 2778.3 2601.5 2598.4 2533.5 2384.8
270.5 273.3 286.1 270.0 215.4 248.7 285.9
1311.1 1281.0 1347.2 1368.7 1330.9 1349.6 939.9
1039.2 883.4 1164.1 954.6 920.8 887.7 954.8
1391.0 1274.2 1297.2 1271.4 1238.6 1016.8 1536.1
4948.0 4635.5 5107.7 4695.6 4967.9 5180.5 4931.7
1263.6 1286.1 1300.9 1405.6 1304.7 1202.0 1439.6
387.0 397.5 486.7 221.6 451.1 423.3 377.0
6254.0 6469.0 5902.7 5965.1 6264.9 6391.9 6322.5
1195.0 1223.6 1231.6 1112.7 1211.8 1194.0 1258.9
66.5 52.4 53.3 54.7 77.9 69.5 82.8
58.3 62.9 61.2 61.1 65.4 55.6 61.2
Minimum Average Maximum
2384.8 2596.6 2778.3
215.4 264.3 286.1
939.9 1275.5 1368.7
883.4 972.1 1164.1
1016.8 1289.3 1536.1
4635.5 4923.8 5180.5
1202.0 1314.6 1439.6
221.6 392.0 486.7
5902.7 6224.3 6469.0
1112.7 1203.9 1258.9
52.4 65.3 82.8
55.6 60.8 65.4
