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 Support		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.

Classification:	Software	Category:	Performance
Platform(s):	IBM System z Family	S/W Pillar(s):	Information Management; System z
O/S:	z/OS	Keywords:	XML, zAAP, zIIP, DB2, pureXML, specialty engine, DB2 9, projectCPU