Abstract:

This presentation will discuss some of the highlights from DB2 9 for z/OS which became generally available in March 2007. XML has come of age with the XML data type for storing documents. This is complemented by many new XML functions which allow a developer to work with both relational data and XML documents at the same time, transforming between the two as and when required. There are many new extensions to the SQL syntax such as the new DML verb MERGE. Performance improves for utilities, optimization and LOBs. DB2 9 builds upon and extends DB2 traditional strengths and the ground-breaking V8 in many areas: online schema evolution, Unicode, XML, DB2 family SQL, utilities, security and 64-bit virtual storage. We will finish by taking at look at some of the key features planned for release with DB2 X.

Mike Bracey is a DB2 for z/OS systems engineer based in the United Kingdom. He has been with IBM for over 26 years and has worked in various capacities as a DB2 branch specialist, DB2 consultant for designing, implementing and tuning applications, and DB2 beta programme manager for Europe. He has extensive practical DB2 experience, gained over 20 years, of DB2 application design, data modelling, and performance monitoring and tuning. He is currently a member of the IBM Software Business in Europe providing technical support for DB2 for z/OS, DB2 Tools and related topics. His current areas of interest are optimization, buffer pool tuning and XML.

	Close this Window
	Last Update: Sunday, 01 November 2009 @ 14:41
	(c) Copyright 2009 GSE UK Region