tpc benchmarktm c full disclosure report for ibm xseries 460...

TPC BenchmarkTM C Full Disclosure Report

for

IBM ^ xSeries 460 using

DB2 Universal Database 8.2and

Microsoft Windows Server 2003 Enterprise x64 Edition

TPC-C Version 5.3

Submitted for Review May 31, 2005

®

First Edition - May 2005

THE INFORMATION CONTAINED IN THIS DOCUMENT IS DISTRIBUTED ON AN AS IS BASISWITHOUT ANY WARRANTY EITHER EXPRESSED OR IMPLIED. The use of this information or theimplementation of any of these techniques is the customer’s responsibility and depends on the customer’s ability toevaluate and integrate them into the customer’s operational environment. While each item has been reviewed byIBM for accuracy in a specific situation, there is no guarantee that the same or similar results will be obtainedelsewhere. Customers attempting to adapt these techniques to their own environment do so at their own risk.

In this document, any references made to an IBM licensed program are not intended to state or imply that onlyIBM’s licensed program may be used; any functionally equivalent program may be used.

This publication was produced in the United States. IBM may not offer the products, services, or features discussedin this document in other countries, and the information is subject to change without notice. Consult your local IBMrepresentative for information on products and services available in your area.

© Copyright International Business Machines Corporation 2005. All rights reserved.

Permission is hereby granted to reproduce this document in whole or in part, provided the copyright notice asprinted above is set forth in full text on the title page of each item reproduced.

U.S. Government Users - Documentation related to restricted rights: Use, duplication, or disclosure is subject torestrictions set forth in GSA ADP Schedule Contract with IBM Corp.

Trademarks

IBM, the IBM logo, DB2, xSeries, ServeRAID, eServer and the eServer logo are trademarks or registeredtrademarks of International Business Machines Corporation.

The following terms used in this publication are trademarks of other companies as follows: TPC Benchmark, tpmC,and $/tpmC trademark of Transaction Processing Performance Council; Intel and Xeon are trademarks or registeredtrademarks of Intel Corporation; Microsoft and Windows are trademarks or registered trademarks of MicrosoftCorporation. Other company, product, or service names, which may be denoted by two asterisks (**), may betrademarks or service marks of others.

Notes1 GHz and MHz only measures microprocessor internal clock speed, not application performance. Many factorsaffect application performance.2 When referring to hard disk capacity, GB, or gigabyte, means one thousand million bytes. Total user-accessiblecapacity may be less.

AbstractIBM Corporation conducted the TPC BenchmarkTM C on the IBM® ^® xSeries ® 460 configured as aclient/server system. This report documents the full disclosure information required by the TPC Benchmark CStandard Specification, Revision 5.3, including the methodology used to achieve the reported results. All testingfully complied with this revision level.

The software used on the xSeries 460 system includes Microsoft® Windows® Server 2003 Enterprise x64 Edition operating system and IBM DB2 Universal Database V8.2 Enterprise Edition database.

Two standard metrics, transactions per minute-C (tpmC) and price per tpmC ($/tpmC), are reported as required bythe TPC Benchmark C Standard Specification.

The benchmark results are summarized in the following table.

November 30, 2005$5.74USD

250,975$1,440,290USD

DB2 UDB 8.2

Microsoft WindowsServer 2003

Enterprise x64 Edition

IBM ^xSeries 460

Total SolutionAvailability Date$/tpmCtpmC

Total SystemCostSoftwareHardware

The results of the benchmark and test methodology used were audited by Francois Raab of InfoSizing, Inc. Theauditor’s attestation letter is contained in Section 9 of this report.

Each of Ten Clients:Intel Xeon DP at 3.4GHz 2MB L2 Cache

512MB256MBUltra320 SCSI Interface36.4GB (15000 rpm)

Qty2/2/4

4 2 1 1

Server:Intel Xeon Processor MP at 3.33GHz/8MB L3Cache4GB ECC RDIMM

ServeRAID-6M Adapter36.4GB 2Gbps FC (15K)36.4GB Ultra320 (15K)18600GB

Qty8/8/16 32 2 500 21

System ComponentProcessors/Cores/ThreadsCache

Memory

Disk ControllersDisk Drives

Total Storage

200,000Microsoft Visual

C++ 6.0 Microsoft COM+

MicrosoftWindows Server

2003 Enterprise x64

Edition

DB2 UDB 8.2

8/8/1664-Bit Intel

XeonTM ProcessorMP at 3.33GHz

Number ofUsersOther SoftwareOperating SystemDatabase Manager

Database ServerProcessors/Cores/

Threads

Nov. 30, 2005$5.74 USD / tpmC250,975 tpmC$1,440,290 USD

Availability DatePrice/PerformanceTPC-C ThroughputTotal System Cost

Report Date: May 31, 2005

TPC-C Rev. 5.3 IBM^ xSeries 460 c/sand

DB2 UDB 8.2

10 x IBM eServer xSeries 22620 x Intel Xeon DP at 3.4GHz

2 x 1Gb/s SwitchEthernet

IBM eServer xSeries 460 and MXE-4608 x Intel Xeon Processor MP at 128GB Memory2 x ServeRAID-6M Adapter8

3.33GHz

x TotalStorage DS4000 Host Bus Adapter

40 x EXP710 Storage50031

x 36.4GB 15K Drive x EXP400 Storage

2 x 36.4GB 15K Drive

RTE RTE

2 2

10 RTEs emulating 200,000 users

Description Part Number Third Party Unit Price Quantity Extended 3-Yr. Maint.Brand Pricing Price Price

Server HardwarexSeries 460 with 2 x 3.33GHz/8MB L3 Cache Intel Xeon Processor MP 8872-3RU IBM 1 24,999 1 24,999xSeries 3.33GHz/8MB L3 Cache Intel Xeon Processor MP 13N0713 IBM 1 5,699 6 34,194MXE-460 (0 Processors, 0 Memory, 2 Memory Cards) 8874-1RU IBM 1 6,999 1 6,999Scalability Cable 2.3.M 13M7414 IBM 1 299 2 5988GB (2x4GB) PC2-3200 CL3 2RX4 ECC DDR2 SDRAM RDIMM 30R5145 IBM 1 17,879 16 286,064Active Memory™ 4-Slot Memory Expansion Card 13M7409 IBM 1 499 4 1,996ServeRAID-6M Ultra320 SCSI Adapter 32P0033 IBM 1 999 2 1,998E54 15" (13.8" Viewable) Color Monitor 633147N IBM 1 149 1 149IBM Preferred Pro Full-Size Keyboard PS/2 31P7415 IBM 1 29 1 29IBM Sleek 2-Button Mouse 28L3673 IBM 1 15 1 15ServicePac for 3-Year 24x7x4 Support (x460 and MXE-460) 96P2253 IBM 1 3,390 2 6,780ServicePac for 3-Year 24x7x4 Support (Monitor) 30L9183 IBM 1 90 1 90Discount on xSeries Hardware (15%) 53,556Discount on ServicePacs (20%) 1,374

Subtotal 303,485 5,496Server StorageIBM TotalStorage DS4000 Host Bus Adapter 24P0960 IBM 1 1,485 8 11,880IBM TotalStorage DS4500 Midrange Disk Subsystem 17429OU IBM 1 49,900 4 199,600IBM DS4000 Mini Hub 19K1269 IBM 1 899 8 7,192IBM Short Wave SFP Module 19K1271 IBM 1 499 168 83,832IBM 1m LC-LC Fibre Channel Cable 19K1247 IBM 1 79 80 6,320IBM 5m LC-LC Fibre Channel Cable 19K1248 IBM 1 129 8 1,032IBM TotalStorage DS4000 EXP710 Storage Exp. Unit 1740710 IBM 1 6,000 40 240,0002Gbps FC 36.4GB 15K Hot-Swap HDD 06P5772 IBM 1 1,115 500 557,500IBM EXP400 Rack Storage Exp. Enclosure 17331RU IBM 1 3,099 3 9,297IBM 36.4GB 15K Ultra320 SCSI Drive 90P1318 IBM 1 349 21 7,3292M SCSI cable 03K9310 IBM 1 75 3 225IBM UPS 750TLV 21301TX IBM 1 299 1 299IBM S2 42U Standard Rack 93074SX IBM 1 1,489 5 7,445ServicePac for 3-Year 24x7x4 Support (EXP710) 41L2768 IBM 1 760 34 25,840ServicePac for 3-Year 24x7x4 Support (DS4500) 96P2062 IBM 1 1,087 5 5,435ServicePac for 3-Year 24x7x4 Support (Rack) 41L2760 IBM 1 300 5 1,500Discount on Fibre Channel Disks (30%) 167,250Discount on Fibre Channel Storage (20%) 109,971Discount on xSeries Storage (15%) 3,689Discount on ServicePacs (20%) 6,555

Subtotal 851,041 26,220Server SoftwareDB2 UDB ESE 8.2 for Windows Operating Systems on 64-Bit IBM 2 22,608 8 180,864 Extended Systems - SW License and Maintenance 12 MonthsSW Maintenance Renewal - 1 Year IBM 2 1,077 16 17,232Microsoft Windows Server 2003 Enterprise x64 Edition* P72-00264 Microsoft 3 2,334 1 2,334Microsoft Problem Resolution Services Microsoft 3 245 1 245

Subtotal 183,198 17,477Client Hardware x226 with 3.4GHz/2MB Xeon DP, 512MB (2x256MB) Memory 8648-6AU IBM 1 1,939 10 19,3903.4GHz/2MB Xeon DP Processor Upgrade 13N0674 IBM 1 1,049 10 10,4901GB (2x512MB) PC-3200 DDR2 ECC SDRAM RDIMM 73P3522 IBM 1 399 20 7,98036.4GB 10K Ultra320 SCSI Drive 90P1304 IBM 1 329 10 3,290PRO/1000 MT Dual-Port Server Adapter 73P2701 Intel 1 249 10 2,490E54 15" (13.8" Viewable) Color Monitor 633147N IBM 1 149 10 1,490ServicePac for 3-Year 24x7x4 Support (x226) 96P2250 IBM 1 750 10 7,500ServicePac for 3-Year 24x7x4 Support (Monitor) 30L9183 IBM 1 90 10 900Discount on xSeries Hardware (15%) 6,770Discount on ServicePacs (20%) 1,680

Subtotal 38,361 6,720Client Software Microsoft Windows 2000 Server with COM+* C11-00821 Microsoft 3 738 10 7,380Microsoft Visual C++ Professional 6.0 254-00170 Microsoft 3 109 1 109

Subtotal 7,489Network ComponentsDLink Gigabit Ethernet Switch (2 spares) 4 189 4 756Ethernet Cable 14 Ft. (2 spares) 4 4 12 48 Subtotal 804Discounts based on volume purchase; prices vary if purchased separately.

Total 1,384,377 55,913$1,440,290

2 - IBM DB2: Bernard Spang, Dir. Database Marketing Management, [email protected], 914-766-1491. tpmC: 250,9753 - Microsoft (*See Quote for Discounts); 4 - newegg.com $ USD/tpmC: $5.74Audited by Francois Raab, InfoSizing, Inc

IBM Corporation with DB2 UDB 8.2

IBM ^ xSeries 460 c/s

Three-Year Cost of Ownership USD:

Report Date: May 31, 2005

TPC-C Revision 5.3

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.

the pricing sections of the TPC benchmark specifications. If you find that stated prices are not available according to these terms, please inform the TPC at pricing @ tpc.org.

For Pricing and Ordering Information: 1- IBM (1-888-SHOP-IBM, Keycode 7764);

Special prices based on assumptions about past or future purchases are not permitted. All discounts reflect standard pricing policies for the listed components. For complete details, see

66,992,300Number of transactions (all types) completed in measurement interval NACheckpoint intervalNANumber of checkpoints

120 minutesMeasurement interval57 minutes 40 secondsRamp-up time

Test Duration

2.02 / 100.332.00 / 10.042.00 / 0.00Order Status2.02 / 50.312.00 / 5.042.00 / 0.00Stock Level2.02 / 50.312.00 / 5.032.00 / 0.00Delivery3.02 / 120.333.00 / 12.043.00 / 0.00Payment

18.03 / 120.3318.00 / 12.0418.00 / 0.00New Order

MaximumAverageMinimum Keying/Think Times(in seconds)

4.01Order Status4.01Stock-Level4.01Delivery43.02Payment44.96New-Order

PercentTransaction Mix (in percent of total transactions)

Response Time Delay Added for Emulated Components: 0.1 Seconds1.590.210.29Menu2.780.300.48Delivery (Deferred)1.940.240.42Order Status2.050.330.42Stock Level1.520.300.30Delivery3.340.320.40Payment1.800.210.34New-Order

MaximumAverage90th PercentileResponse Times(in seconds)

MQTh, Computed Maximum Qualified Throughput: 250,975 tpmC

Numerical Quantities Summary

Table of Contents

46Operator Intervention . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46Network Bandwidth . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46Network Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46Benchmarked and Targeted System Configuration Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46Emulated Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46Description of RTE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46Clause 6: SUT, Driver and Communication Definition Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .45Number of Checkpoints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44Percentage of Total Mix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44Transaction Mix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44Measurement Interval . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43Work Performed during Steady State . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .43Steady State Methodology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .42New Order Think Time Distribution . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .41Performance Curve for Response Time vs. Throughput . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .39Response Time Frequency Distribution Curves . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38Keying/Think Times . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38Response Times . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38Measured tpmC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38Clause 5: Performance Metrics and Response Time Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3760-Day Space Requirement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36Partitions/Replications Mapping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .36Database Model Implemented . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21Distribution of Tables and Logs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21Cardinality of Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .21Clause 4: Scaling and Database Population Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19Durability Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .19Isolation Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18Consistency Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18Atomicity Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .18Clause 3: Transaction and System Properties Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .17Deferred Delivery Mechanism . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16Transaction Profiles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16Intelligent Terminals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16Terminal Verification . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16Screen Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16Random Number Generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16Clause 2: Transaction and Terminal Profiles Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Table Attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Horizontal or Vertical Partitioning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Insert and Delete Operations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Physical Organization of the Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Table Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Clause 1: Logical Database Design Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13Configuration Diagrams . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13Parameter Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13Benchmark Sponsor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13Application Code Disclosure and Definition Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13General Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

5Numerical Quantities Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3Abstract . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

© IBM Corporation - TPC Benchmark C Full Disclosure Report - May 2005 7

160tpccCom/dlldatax.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .159tpccCom/comreg.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .158utils/UNEXPLAIN.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .154utils/EXPLAIN.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .154Src.Srv/rpctpcc.def . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .154Src.Srv/uncat_proc.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .154Src.Srv/uncat_func.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .128Src.Srv/tpcc_all_sql.sqc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .128Src.Srv/cat-proc.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .123Src.Srv/cat-func.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .121Src.Srv/Makefile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .121Src.Common/tpccmisc.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .117Src.Common/tpccdbg.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .116Src.Common/tpccctx.sqc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .115Src.Common/Makefile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .115include/tpccdbg.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .114include/tpccapp.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .114include/lval.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .112include/db2tpcc.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .112tpccenv.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111Makefile.config . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111A.2 Client Transaction Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

86tpccIsapi/tpccIsapi.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86tpccIsapi/StdAfx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .84tpccIsapi/htmlPhraser.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .83tpccIsapi/tpccIsapi.hpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .83tpccIsapi/tpccIsapi.def . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .73tpccIsapi/tpcc.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .73tpccIsapi/StdAfx.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .73tpccIsapi/resource.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .72tpccIsapi/htmlPhraser.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .72nullDB/stdafx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .72nullDB/stdafx.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .69nullDB/nullDB.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .63Src.Cli/tpcccli.sqc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .62Src.Cli/Makefile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .58Src.Common/tpccdbg.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57Src.Common/tpccctx.sqc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .56Src.Common/Makefile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55include/tpccdbg.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55include/tpccapp.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52makefile.config . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52A.1 Client/Terminal Handler Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52Appendix A: Client Server Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .50Attestation letter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49Availability of the Full Disclosure Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49Auditor . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49Clause 9: Audit Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .48System Pricing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47Usage Pricing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47Country-Specific Pricing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47Measured tpmC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47Availability Date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47Hardware and Software Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .47Clause 7: Pricing Related Items . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


270cridx__cust_idxb.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .268crconst_warehouse.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .267crconst_stock.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266crconst_orders.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .264crconst_order_line.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .262crconst_new_orderb.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .261crconst_new_ordera.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .259crconst_history.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .258crconst_district.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .257crconst_customer.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .255alttbsp_pf_4096.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .252alttbsp_pf_1024.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .250alttbsp_pf_0.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .250create_database.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .250create_bufferpool.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .249alter_bufferpool.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .247alter_tablespace.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .235create_tablespace.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .235Appendix B: Database Design Scripts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .234TpccIsapi.rc . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .232TpccIsapi.hpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .232TpccIsapi.def . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .205TpccIsapi.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .194Tpcc.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .194StdAfx.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .194StdAfx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .193Resource.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .192HtmlPhraser.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .190HtmlPhraser.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .189TpccComClient.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .189StdAfx.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .189Stdafx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .188Stdafx.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .188Stdafx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .188NullDB.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .185NullDB.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .180tpccDB2Glue/tpccDB2glue.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .180tpccDB2Glue/stdafx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .180tpccDB2Glue/tpccDB2glue.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .180TpccDB2Glue/stdfax.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .169tpccCom/tpccCom_p.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .169tpccCom/tpccCom_i.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .168tpccCom/dlldatax.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .168TpccCom/dlldata.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .164tpccCom/tpcc_com.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .164tpccCom/tpccCom.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .164tpccCom/stdafx.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .164tpccCom/comreg.cpp . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .163tpccCom/tpcc_com.rgs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .163tpccCom/tpccCom.idl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .163tpccCom/tpccCom.def . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .162tpccCom/tpcc_com.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .160tpccCom/tpccCom.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .160tpccCom/stdafx.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .160tpccCom/Resource.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


350dbgen\include\tpccrnd.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .350dbgen\include\platform.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .349dbgen\include\lval.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .347dbgen\include\db2tpcc.h . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .345dbgen\tpccrnd.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .344dbgen\makefile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .336dbgen\gendata.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .336DBGEN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .335rnst_warehouse.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .334rnst_stock.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .334rnst_orders.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .333rnst_order_line.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .332rnst_new_orderb.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .331rnst_new_ordera.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .331rnst_item.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .330rnst_history.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .329rnst_district.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .328rnst_customer.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .327load_warehouse_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .326load_stock_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .324load_orders_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .323load_order_line_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .322load_new_order_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .322load_item_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .320connect to TPCC in share mode; . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .320Load_history_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .319load_district_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .318load_customer_all.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .317gen_warehouse.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .317gen_stock.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .316gen_orders.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .316gen_new_order.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .316gen_item.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314gen_history.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314gen_district.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314gen_customer.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .313crvw_warehouse.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .313crvw_stock.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .313crvw_orders.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .312crvw_order_line.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .312crvw_new_order.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .311crvw_history.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .311crvw_district.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .311crvw_customer.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .307crtb_warehouse.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .304crtb_history.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .298crtb_stock.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .295crtb_new_orderb.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .292crtb_new_ordera.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .287crtb_order_line.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .283crtb_orders.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .279crtb_district.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .279crtb_item.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .272crtb_customer.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .271cridx_ordr_idxb.ddl . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


545Appendix E: Third-Party Quotations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .544Appendix D: 60-Day Space . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .542RTE Input Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .540Microsoft Windows 2000 Client Registry Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .540Client Configuration Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .505Microsoft Windows 2000 Client System Information Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .505Client Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .446DS4500 Disk Subsystem Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .441ServeRAID-6M Disk Controller Configuration Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .357System Information Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .357Server Configuration Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .357Microsoft Windows Server 2003 Enterprise x64 Edition . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .357Aff.cfg . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .357DB2set Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .355Database Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .354Database Manager Configuration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .354IBM DB2 UDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .354Appendix C: Tunable Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .352dbgen\tpccenv.bat . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .352dbgen\Src.Common\tpccmisc.c . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .351dbgen\Src.Common\makefile . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .350dbgen\makefile.config . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .


PrefaceThe TPC BenchmarkTM C was developed by the Transaction Processing Performance Council (TPC). The TPC wasfounded to define transaction processing benchmarks and to disseminate objective, verifiable performance data tothe industry. This full disclosure report is based on the TPC Benchmark C Standard Specification Version 5.3.

The TPC describes this benchmark in Clause 0.1 of the specification as follows:

TPC Benchmark C is an On Line Transaction Processing (OLTP) workload. It is a mixture of read-only andupdate-intensive transactions that simulate the activities found in complex OLTP application environments. It doesso by exercising a breadth of system components associated with environments, which are characterized by:

v The simultaneous execution of multiple transaction types that span a breadth of complexityv On-line and deferred transaction execution modesv Multiple on-line terminal sessionsv Moderate system and application execution timev Significant disk input/outputv Transaction integrity (ACID properties)v Non-uniform distribution of data access through primary and secondary keysv Databases consisting of many tables with a wide variety of sizes, attributes and relationshipsv Contention on data access and update

The performance metric reported by TPC-C is a “business throughput” measuring the number of orders processedper minute. Multiple transactions are used to simulate the business activity of processing an order, and eachtransaction is subject to a response time constraint. The performance metric for this benchmark is expressed intransactions-per-minute-C (tpmC). To be compliant with the TPC-C standard, all references to tpmC results mustinclude the tpmC rate, the associated price-per-tpmC, and the availability date of the priced configuration.

Despite the fact that this benchmark offers a rich environment that emulates many OLTP applications, thisbenchmark does not reflect the entire range of OLTP requirements. In addition, the extent to which a customer canachieve the results reported by a vendor is highly dependent on how closely TPC-C approximates the customerapplication. The relative performance of systems derived from this benchmark does not necessarily hold for otherworkloads or environments. Extrapolations to any other environment are not recommended.

Benchmark results are highly dependent upon workload, specific application requirements, and systems design andimplementation. Relative system performance will vary as a result of these and other factors. Therefore, TPC-Cshould not be used as a substitute for a specific customer application benchmarking when critical capacity planningand/or product evaluation decisions are contemplated.


General ItemsBenchmark Sponsor

A statement identifying the benchmark sponsor(s) and other participating companies must be provided.

This benchmark was sponsored by International Business Machines Corporation.

Application Code Disclosure and Definition Statements

The application program (as defined in Clause 2.1.7) must be disclosed. This includes, but is not limited to, the codeimplementing the five transactions and the terminal input and output functions.

Appendix A contains all source code implemented in this benchmark.

Parameter Settings

Settings must be provided for all customer-tunable parameters and options that have been changed from thedefaults found in actual products, including but not limited to:

v Database tuning optionsv Recovery/commit optionsv Consistency/locking optionsv Operating system and application configuration parameters.v Compilation and linkage options and run-time optimizations used to create/install applications, OS, and/or

databases.This requirement can be satisfied by providing a full list of all parameters and options.

Appendix C contains the tunable parameters for the database, the operating system, and the transaction monitor.

Configuration Diagrams

Diagrams of both measured and priced configurations must be provided, accompanied by a description of thedifferences.

The configuration diagrams for the tested and priced systems are provided on the following pages.

The Remote Terminal Emulator (RTE) used for these TPC Benchmark C tests is an IBM proprietary RTE. UnderVersion 5.3, the components of the configuration being emulated by the RTE are the workstations and the Ethernethubs. Appendix C contains a listing of the RTE scripts and inputs used in the benchmark testing.

The benchmarked configuration used 10 IBM eServer xSeries 226 systems, each configured with two 3.4GHz IntelXeon processors, as the clients, which executed the terminal I/O and submitted transactions to COM+ servers,which are also running on the clients. These COM+ servers forwarded the transaction requests to the server, andreturned the results to the RTE. DB2 UDB 8.2 is the DBMS executing on the server


Measured Configuration

10 x IBM eServer xSeries 22620 x Intel Xeon DP at 3.4GHz

2 x 1Gb/s SwitchEthernet

IBM eServer xSeries 460 and MXE-4608 x Intel Xeon Processor MP at 128GB Memory2 x ServeRAID-6M Adapter8

3.33GHz

x TotalStorage DS4000 Host Bus Adapter

40 x EXP710 Storage50031

x 36.4GB 15K Drive x EXP400 Storage

2 x 36.4GB 15K Drive

RTE RTE

2 2

10 RTEs emulating 200,000 users

The measured and priced configurations were identical. For the priced configuration, see the Executive Summary.


Clause 1: Logical Database Design Related ItemsTable Definitions

Listings must be provided for all table definition statements and all other statements used to set up the database. Appendix B contains the code used to define and load the database tables.

Physical Organization of the Database

The physical organization of tables and indexes within the database must be disclosed. Physical space was allocated to DB2 UDB on the server disks as detailed in Figure 4-2.

Insert and Delete Operations

It must be ascertained that insert and/or delete operations to any of the tables can occur concurrently with theTPC-C transaction mix. Furthermore, any restriction in the SUT database implementation that precludes insertsbeyond the limits defined in Clause 1.4.11 must be disclosed. This includes the maximum number of rows that canbe inserted and the maximum key value for these new rows. All insert and delete functions were fully operational during the running of the benchmark. The space required foran additional 5 percent of the initial table cardinality was allocated to DB2 UDB and priced as static space.

Horizontal or Vertical Partitioning

While there are few restrictions placed upon horizontal or vertical partitioning of tables and rows in the TPC-Cbenchmark (see Clause 1.6), any such partitioning must be disclosed.

All tables except Item table were horizontally partitioned into 25 tables of 800 warehouses each. For eachpartitioned table, a view was created over all table partitions to provide full transparency of data manipulation.

Replication

Replication tables, if used, must be disclosed (see Clause 1.4.6). Replication was not used in this benchmark.

Table Attributes

Additional and/or duplicated attributes in any table must be disclosed, along with a statement on the impact onperformance (see Clause 1.4.7). No additional attributes were used in this benchmark.


Clause 2: Transaction and Terminal Profiles Related ItemsRandom Number Generation

The method of verification for the random number generation must be disclosed. The seeds and offsets for the random number generator were collected and verified to be different for each driver.The auditor selected samples of the generated numbers from the database. The samples were verified to have nodiscernible patterns.

Screen Layout

The actual layouts of the terminal input/out screens must be disclosed. All screen layouts followed the TPC Benchmark C Standard Specification.

Terminal Verification

The method used to verify that the emulated terminals provide all the features described in Clause 2.2.2.4 must beexplained. Although not specifically priced, the type and model of the terminals used must for the demonstration in8.1.3.3 must be disclosed and commercially available (including supporting software and maintenance). The auditor verified terminal features by direct experimentation. The benchmarked configuration uses MicrosoftInternet Explorer 6.0 SP1 and HTML scripts as the terminal interface.

Intelligent Terminals

Any usage of presentation managers or intelligent terminals must be explained. The terminals emulated in the priced configuration are IBM PC desktop computer systems. All processing of theinput/output screens was handled by the xSeries 226 clients. The screen input/output was managed via HTMLstrings that comply with the HTML Version 2.0 specification.A listing of the code used to implement the intelligentterminals is provided in Appendix A. All data manipulation was handled by the xSeries 460 database server.

Transaction Profiles

The percentage of home and remote order-lines in the New-Order transactions must be disclosed. The percentage of New-Order transactions that were rolled back as a result of an unused item number must bedisclosed.

The number of items per orders entered by New-Order transactions must be disclosed. The percentage of home andremote Payment transactions must be disclosed. The percentage of Payment and Order-Status transactions thatused non-primary key (C_LAST) access to the database must be disclosed. The percentage of Delivery transactions that were skipped as a result of an insufficient number of rows in theNEW-ORDER table must be disclosed. The mix (i.e., percentages) of transaction types seen by the SUT must be disclosed.


Table 2-1. Transaction Statistics

4.01Order Status4.01Stock Level4.01Delivery

43.02Payment44.96New-Order

Transaction Mix0Delivery transactions skipped

Delivery59.99Order-Status transactions using C_LAST60.00Payment transactions using C_LAST

Non-Primary Key Access0.15Remote warehouse payment transactions0.85Home warehouse payment transactions

Payment10.00Average number of items per order1.00Rolled back transactions 1.00Remote warehouse order lines

99.00Home warehouse order lines

Value (%)New Order

Deferred Delivery Mechanism

The queuing mechanism used to defer execution of the Delivery transaction must be disclosed. The Delivery transaction was submitted to an ISAPI queue that is separate from the COM+ queue that the othertransactions used. This queue is serviced by a variable amount of threads that are separate from the worker threadsinside the web server. Web server threads are able to complete the on-line part of the Delivery transaction andimmediately return successful queuing responses to the drivers. The threads servicing the queue are responsible forcompleting the deferred part of the transaction asynchronously.

The source code is listed in Appendix A.


Clause 3: Transaction and System Properties Related ItemsThe results of the ACID test must be disclosed, along with a description of how the ACID requirements were met.This includes disclosing which case was followed for the execution of Isolation Test 7. Atomicity Requirements

The system under test must guarantee that database transactions are atomic; the system will either perform allindividual operations on the data, or will assure that no partially completed operations leave any effects on thedata.All ACID tests were conducted according to specification.

Completed Transactions

The following steps were performed to verify the Atomicity of completed transactions.1. The balance was retrieved from the CUSTOMER table for a random Customer, District and Warehouse,

giving BALANCE_1.2. The Payment transaction was executed for the Customer, District and Warehouse used in step 1.3. The balance was retrieved again for the Customer used in step 1 and step 2, giving BALANCE_2. It was

verified that BALANCE_1 was greater than BALANCE_2 by AMT.

Aborted Transactions

The following steps were performed to verify the Atomicity of the aborted Payment transaction:1. The Payment application code was changed to execute a rollback of the transaction instead of performing

the commit.2. Using the balance, BALANCE_2, from the CUSTOMER table retrieved for the completed transaction, the

Payment transaction was executed for the Customer, District and Warehouse used in step 1 of section3.1.1. The transaction rolled back due to the change in the application code from step 1.

3. The balance was retrieved again for the Customer used for step 2, giving BALANCE_3. It was verifiedthat BALANCE_2 was equal to BALANCE_3.

Consistency Requirements

Consistency is the property of the application that requires any execution of a database transaction to take thedatabase from one consistent state to another, assuming that the database is initially in a consistent state. Consistency conditions one through four were tested using a bat file to issue queries to the database.The results ofthe queries demonstrated that the database was consistent for all four tests.


Isolation Requirements

Sufficient conditions must be enabled at either the system or the application level to ensure that the requiredisolation defined in Clause 3.4.1 is obtained.

Isolation tests one through seven were run using the bat files to issue queries to the database. Each file includedtimestamps to demonstrate the concurrency of operations. The results of the queries were captured and placed infiles. The auditor reviewed the results and verified that the isolation requirements had been met.

In addition, the phantom tests and the stock-level tests were run and verified.

Case A was followed for Isolation test seven.

Durability Requirements

The tested system must guarantee durability: the ability to preserve the effects of committed transactions and ensuredatabase consistency after recovery from any one of the failures listed in Clause 3.5.3. v Permanent irrecoverable failure of any single durable medium containing TPC-C database tables or recovery

log data (this test includes failure of all or part of memory)v Instantaneous interruption (system crash/system hang) in processing that requires system reboot to recover v Failure of all or part of memory (loss of contents)

Loss of Data Test

The DS4500 Disk Subsystem contains two RAID controller blades, which provide RAID functionality to theattached disks. Each RAID controller blade contains a Read/Write cache. Write caching was enabled. The attacheddisks contained a portion of each of the tables in the tpcc database. During steady state one RAID controller bladewas desinserted causing DB2 to report errors accessing that device.

The following steps were successfully performed to pass the Durability test of failure of a DS4500 controller withdatabase tables:

1. The contents of the database were backed up to several database dump devices during the initial databaseload.

2. The current count of the total number of orders was determined by the sum of D_NEXT_O_ID for all rowsin the district table giving SUM1.

3. A test was started with 60,800 users submitting transactions. 4. A DS4500 controller blade containing a portion of each of the tables in the tpcc database was pulled out

causing DB2 to report errors accessing that device. 5. The run was aborted and DB2 was stopped. 6. The failed DS4500 controller blade was reinserted and was recovered. 7. The database was recovered and restored from the backup dump devices. Afterwards, the transaction log

was rolled forward to the database. 8. Step 2 was repeated to obtain the current count of the total number of orders giving SUM2.9. It was verified that the sum of D_NEXT _O_ID after the database is recovered is greater than or equal to

the sum of D_NEXT_O_ID before the run, plus all new order transactions completed during the run minusany rollback transactions.

10. Consistency Condition 3 was verified.

Loss of Log and Loss of System (Instantaneous Interruption and Loss ofMemory)

1. The current count of the total number of orders was determined by the sum of D_NEXT_O_ID for all rowsin the district table gving SUM1.

2. This test was executed on a full scale benchmark run with 200,000 users.


3. The test continued to run for 5 minutes after all users were connected to the server. 4. One disk from the log array was removed. Since the disk was RAID-1 mirrored, DB2 continued to process

transactions without interruption.5. The test continued to run for another 5 minutes. 6. The server under test was powered off, which removed power from the system and the memory.7. The server was powered on again. 8. DB2 was allowed to recover. 9. Step 1 was repeated to obtain the current count of the total number of orders giving SUM2.

10. It was verified that the sum of D_NEXT_O_ID after the database recovered was greater than or equal tothe sum of D_NEXT_O_ID before the run, plus all new order transactions completed during the run minusany rollback transactions.


Clause 4: Scaling and Database Population Related Items Cardinality of Tables

The cardinality (e.g., the number of rows) of each table, as it existed at the start of the benchmark run (see Clause4.2), must be disclosed. If the database was over-scaled and inactive rows of the WAREHOUSE table were deleted(see Clause 4.2.2), the cardinality of the WAREHOUSE table as initially configured and the number of rows deletedmust be disclosed. The database was built with 20,000 warehouses and the audited run used 20,000 warehouses. Table 4-1. Initial Cardinality of Tables

0Inactive Warehouses

2,000,000,000Stock6,000,180,579Order Line600,000,000Customer600,000,000Orders600,000,000History180,000,000New Order

100,000Item200,000District20,000WarehouseRowsTable Name

Distribution of Tables and Logs

The distribution of tables and logs across all media must be explicitly depicted for the tested and priced systems.

The logs are configured as a RAID-10 disk array with 20 physical disks of 36.4GB each attached via an internalServeRAID-6M adapter.

For the database tables, there is a total of 500 disk drives. Each physical disk has a capacity of 36.4GB. A total ofeight Fibre Channel storage adapters connect these 500 disks.

Each disk volume, as seen by the Windows operating system, is configured as a RAID-0 disk array with 10 physicaldisks. There is a total of 50 such disk volumes. Each disk volume is further partitioned into 12 partitions. Eachpartition corresponds to a DB2 container.

Each partition within a partitioned table is made of two DB2 containers; thus, there are 25 partitioned tables with atotal of 50 DB2 containers so that the corresponding view spans all eight adapters connected to the 500 disks.

The ITEM table, which is not paritioned, is made up of 50 DB2 containers and also span all eight adapters.

A total of 60 drives held six RAID-5 arrays, which were used to store the backup image only. These 60 drives werenot priced.

Figure 4-2 depicts the database configuration of the tested and priced systems to meet the 8-hour steady staterequirement.


Figure 4-2. Data Distribution for the Benchmarked Configuration

DatabaseBackup Files

334.00GBC:\Containers\ITM\004C:\Containers\WAR\004C:\Containers\DIS\004C:\Containers\CSTI\004C:\Containers\NEWA\004C:\Containers\OLN\004C:\Containers\STK\004C:\Containers\CST\004C:\Containers\ORDI\004C:\Containers\ORD\004C:\Containers\HST\004C:\Containers\NEWB\004

10 - 36.4GB EXP710 Enclosure

3




2




1




0UseSizePartitionDrivesDisk #


Backup Files300.60GBC:\Backup10 - 36.4GBEXP710 Enclosure

6




5




4





10




9




8







13




12




11





17




16




15







20




19




18





24




23




22









29




28




27




26




25



34




33




32




31




30





38




37




36







41




40




39





45




44




43


334.00GBC:\Containers\ITM\038C:\Containers\WAR\038C:\Containers\DIS\038C:\Containers\CSTI\038C:\Containers\NEWA\038C:\Containers\OLN\038C:\Containers\STK\038C:\Containers\CST\038C:\Containers\ORDI\038C:

tpc benchmarktm c full disclosure report for ibm xseries 460...

Documents