TPC-H Rev. 1.3.0
IBM NUMA-Q 2000 with DB2 UDB 7.1
Report Date: November 24, 2000
Total System Cost
Composite Query per Hour Rating
Price/Performance
$4,516,767
7,334.4
$616
Database Size 300GB
QphH@300GB Operating System DYNIX/ptx 4.5.1
$/QphH@300GB Availability Date August 15, 2000
Database Manager DB2 UDB 7.1
Other Software None
131.5
RF1 RF2
864.6 Power Test
Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15a Q16 Q17 Q18 Q19 Q20 Q21 Q22
Throughput Test Arithmetic Mean (from Throughput Test)
Geometric Mean (from Power Test)
0
1000
2000
3000
Query Time in Seconds
Database Load Time: 3:10:22 Load included backup: N Total Data Storage/Database Size: 19.05 RAID (base tables): N RAID (Base Tables and Auxiliary Data Structures): Y RAID (All): N
System Components Processors Memory Disk Drives Total TB Storage
64 x Pentium(r) III Xeon (tm) 700 MHz Processors with 2MB Cache 64 GB memory 9 18.2 GB Disk Drives (scsi, 17501 MB) 640 9.1 GB Disk Drives (fibre channel, 8683 MB) 5.45 TB
TPC-H Rev. 1.3.0
IBM NUMA-Q 2000 with DB2 UDB 7.1 Description
Part Number
Source
Unit Price
Server Hardware NUMA BASE Console, ethernet CON-0300 IBM 4,290 Console country kit for NAO, includes power cord and modem IOC-0021-30 IBM 0 Bundle: 16 NUMA-Q 2000 Quads w/4x 700 MHz 2MB,QUAD-0414-16 1GB Memory, w/o IBM IQ-LINK572,455 IQ-LINK for E4x0 quad IQ-LINK-20 IBM 14,300 32X CD-ROM and QIC525 TAPE DRIVE in a 3.5" PBAY CDR-0005-01 IBM 2,000 18.2 GB Disk in 3.5" PBAY Carrier DSK-1800-33 IBM 1,200 3.5" PBAY with N+1 redundant power (3 power supplies) EXP-PBAY-04 IBM 3,185 24GB Memory Add-on for 300 Series Quad MEM-1200-24 IBM 132,600 PCI-SCSI Controller IOC-0120-51 IBM 715 4 Port Ethernet Controller for 64 bit PCI, 10/100 COM-0040-51 975 Mbps, IBM Rev.4, PCI/Fibre Channel Controller w/multi-mode IOC-0210-54 2,612 NON-OFC GLM, 500M IBM IQ Plus-IQ Link Interconnect Cable CBL-PLUS-03 IBM 455 SCSI PBAY Cable CBL-0300-RL IBM 59 Enterprise (large) NUMA-Q Cabinet CABE-2000-02 IBM 6,500 Subtotal Server Storage CLARiiON FC DAE with 4, 9.1GB (10k 512byte) disk drives CLARiiON single 9.1GB (10k 512 byte) drive 8 meter, multi-mode, Fibre Channel cable for all MM FC connections 3 meter, multi-mode, Fibre Channel cable for all MM FC connections Enterprise (large) NUMA-Q Cabinet
Report Date: November 24, 2000
Extended Price
Qty 1
4,290
1 1 16 1 9 1 2 1
0 572,455 228,800 2,000 10,800 3,185 265,200 715
1
975
64 16 1 4
167,149 7,280 59 26,000 1,288,908
DSK-F520-41
IBM
8,338
64
DSK-F040-40 CBL-2000-F3
IBM IBM
879 101
384 40
IBM
88
24
IBM IBM IBM IBM IBM IBM IBM IBM IBM IBM IBM
6,500 Subtotal
7
0 6,497 1,300 36,400 16,046 15,975 6,221 Subtotal
1 1 1 1 1 63 5
5 Years Maint Price
675,111
533,658 337,613 4,030
CABE-2000-02
Server Software Initial 2 users ptx license PTX-BASE-000 Dynix/ptx 64 concurrent user license PTX-0064-000 Dynix/ptx v4.5.1 CD-ROM Media for NUMA-Q system PTX-C451-000 - US ptx/SVM v2.1.3 for 16 quads SVM-P002-16 DB2 UDB EEE V7.1 Program Package (1 Proc) 11K7641 DB2 UDB EEE V7.1 Per Additional Proc 11K8164 Support Line Full Shift NUMAQ (one year)
Total Cost of Hardware and Software
Five Years Cost Of Ownership QphH $ / QphH
$ $
2,106 45,500 922,906
199,680
0 6,497 1,300 36,400 16,046 1,006,425 31,105 1,097,773
332,389
3,309,587
1,207,180
4,516,767 7334.4 616
Audited by Brad Askins and Francois Raab for InfoSizing, Inc. Note: Hardware and System Software available May 25, 2000. Database software available August 15,2000.
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 notifiy the TPC at
[email protected]. Thank You.
TPC-H Rev. 1.3.0
IBM NUMA-Q 2000 with DB2 UDB 7.1
Report Date: November 24, 2000
Numerical Quantities Summary
Measurement Results: Database Scaling (SF/Size) Total Data Storage/Database Size Database Load Time Query Streams for Throughput Test TPC-H Power Metric (QppH@300GB) TPC-H Throughput Metric (QthH@300GB) Composite Query-per-Hour Rating (QphH@300GB) Total System Price over 5 years TPC-H Price/Performance Metric ($/QphH@300GB)
= = = = = = = = =
300 19.05 3:10:22 6 8,215 6,548.2 7,334.4 $4,516,767 $616
Measurement Intervals Measurement Interval in Throughput Test (TS) = 21,771 seconds
Duration of Stream Execution Stream ID Stream 00 Stream 01 Stream 02 Stream 03 Stream 04 Stream 05 Stream 06 Refresh
Seed Used 422231817 422231818 422231819 422231820 422231821 422231822 422231823
Start Date 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00
Start Time 00:03:01 01:11:38 01:11:38 01:11:38 01:11:38 01:11:38 01:11:38 01:11:38
End Date 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00 04/23/00
End Time 01:11:24 06:24:30 06:28:54 06:33:03 06:24:37 06:30:46 06:30:14 07:14:29
TPC-H Rev. 1.3.0
IBM NUMA-Q 2000 with DB2 UDB 7.1
Report Date: November 24, 2000
Timing Intervals (in Seconds) Stream ID Q1 Stream 0
156.4
Stream 01
802.0
Q2
Q3
Q4
44.0
248.3
132.0
151.3
1050.4 747.0
Q5
Q6
Q7
Q8
Q9
Q10
Q11
Q12
183.8
23.8
139.5
179.8
328.5
117.7
49.4
121.3
1023.7 60.0
577.4
976.7
1826.4
756.5
272.4
525.7
Stream 02
939.6
115.8
1033.7 728.8
1116.6 80.7
676.1
1033.1
2063.8
638.2
255.6
524.0
Stream 03
911.6
129.6
475.4
1070.8 75.2
620.8
982.5
1743.2
623.1
301.1
703.2
773.8
Stream 04
886.0
75.0
1098.4 717.6
1100.9 87.2
658.2
916.0
1872.0
719.7
151.0
780.5
Stream 05
853.2
147.4
943.5
1085.5 102.4
693.0
929.6
1721.4
607.3
197.5
765.4
Stream 06
919.0
121.1
1128.4 771.8
1061.8 68.4
602.0
1044.9
2049.6
751.9
269.1
651.4
702.2
Minimum
802.0
75.0
475.4
702.2
1023.7 60.0
577.4
916.0
1721.4
607.3
151.0
524.0
Average
885.2
123.4
955.0
740.2
1076.6 79.0
637.9
980.5
1879.4
682.8
241.1
658.4
Maximum
939.6
151.3
1128.4 773.8
1116.6 102.4
693.0
1044.9
2063.8
756.5
301.1
780.5
Stream ID Q13
Q14
Q15a Q16
Q17
Q18
Q19
Q20
Q21
Q22
RF1
RF2
Stream 0
293.2
31.1
394.1
112.9
Stream 01
1330.4 92.9
62.0
110.1
210.4
338.9
442.0
1479.3 1758.2 660.4
53.4
456.4
259.2
260.0
129.5
133.2
2610.9
1154.6
254.0
137.9
Stream 02
1237.6 103.8
319.2
468.8
1288.4 1757.9 727.6
169.6
2407.1
1349.0
294.6
133.0
Stream 03
1661.9 108.3
295.0
443.6
1534.4 1952.2 637.0
185.9
2721.5
1332.5
292.7
128.8
Stream 04
1255.9 96.5
316.6
347.7
1479.0 1763.5 762.1
127.0
2479.2
1087.2
283.4
133.5
Stream 05
1545.1 75.5
299.7
437.1
1320.9 2027.6 678.8
165.0
2533.0
1314.6
289.5
130.2
Stream 06
1449.6 120.5
244.3
392.5
1293.1 1803.9 720.6
134.2
2292.9
1222.8
287.1
121.1
Minimum
1237.6 75.5
244.3
347.7
1288.4 1757.9 637.0
127.0
2292.9
1087.2
254.0
121.1
Average
1413.4 99.6
302.3
422.0
1399.2 1843.9 697.8
152.5
2507.4
1243.5
283.6
130.8
Maximum
1661.9 120.5
338.9
468.8
1534.4 2027.6 762.1
185.9
2721.5
1349.0
294.6
137.9