DB2 9 XML Performance Characteristics: Use the TPoX Benchmark to Test the Performance of a Simulated Brokerage Scenario

Overview

The goal of this performance study was to demonstrate operating performance characteristics using the latest IBM server hardware, storage, AIX operating system, and DB2 9 software for an XML workload. The TPoX benchmark was used to achieve this goal. All tests used DB2's new STMM and automatic storage features. The author feels that the workload scenario is representative of a significant class of XML applications including message-based transaction processing as well as Web service application dealing with large numbers of small XML documents. The paper chose the financial industry due to its experience with it and its adoption of a mature, standardized XML schema, FIXML.