Skip to main content

Techdocs Library > White papers >

DB2 9 and z/OS XML System Services Synergy Update



Document Author:
Additional Author(s):

Judy Ruby-Brown
Akiko Hoshikawa


Document ID:

WP101227


Doc. Organization:

Advanced Technical Sales


Document Revised:

05/11/2008


Product(s) covered:

DB2 for z/OS and OS/390; z/OS







Abstract: The white paper, “DB2 9 and XML DB2 9 and z/OS XML System Services Synergy”, was published in August, 2007, http://www.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP101088. It focused on initial measurements for pureXML™ technology using DB2® Version 9.1 for z/OS® (DB2 9 hereafter) as an exploiter of z/OS XML System Services. This paper can be read instead of its predecessor if it is desired. New topics for this paper:
1. New accounting fields have been provided in the DB2 trace records.
2. The workload has been run on a later version of the z/OS operating system and comparisons are documented.
3. The workload has been expanded to incorporate more XML benchmarks runs, including query. This is known as “mixed workload.”.
Measurements including zAAP redirection is shown for workloads such as the DB2 LOAD utility, TPoX Insert workload comparing z/OS 1.9 to z/OS 1.8, and a mixed TPoX workload (query and inserts). The RMF Workload Activity Report and OMPE DB2 Accounting trace show the breakdown of CPU that ran on GP engines and on specialty engines.

ZSW03034-USEN-00.pdf



Classification:

Software

Category:

Performance




Platform(s):

IBM System z Family

S/W Pillar(s):

Information Management; IBM System z Software

O/S:

z/OS

Keywords:

XML, zAAP, zIIP, DB2, pureXML, specialty engine, DB2 9, projectCPU

The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: