Partition By Growth Table Spaces - Partition 1, Getting Started Universal Table Space (UTS) Universal Table Spaces (UTS) were introduced in Db2 9 to bring together the advantages of partitioned table spaces, where you can have a capacity >64Gb, and segmented table...
Bring Intelligence to Where Critical Transactions Run – An Update from Machine Learning for z/OS Authors: Kewei Wei(魏可伟), Senior Technical Staff Member, Lead Architect of Machine Learning for z/OS, IBM China Development Lab; Guanjun Cai, Information architect and developer for IBM...
Potential SQL Performance Improvements in DB2 11 for z/OS By Daniel L Luksetich, IDUG DB2 11 White Paper Editorial Committee As with any new release of DB2 for z/OS there comes a host of SQL performance improvements. Some of these you get straight away, some with a bind or next prepare...
DB2 11 for z/OS XML Features – The Hierarchy Strikes Back By Isaac Yassin, IDUG DB2 11 White Paper Editorial Committee Within few months we’ll have DB2 for z/OS next incarnation – the 11 th in number (Sequoia – DB2 11). A group of dedicated DB2 bigots J have embarked on the mission to...
This presentation looks at the performance impact of DB2 z/OS V9, especially performance scalability of transactions, CPU and elapsed time of queries and utilities, and other performance-related topics.
EU07A15.flv
Although DB2 9 for z/OS has not yet been officially announced by IBM, there is significant information available in the public domain. The snag is, this is well spread out and mostly written by IBM - the database vendor This presentation looks at what MIGHT be coming in DB2 9 (no-one knows for...
EU07A01.flv
A new variation of SQL procedures, native SQL procedures, are introduced in DB2 9 for z/OS. Richer support of the SQL Procedural Language, and attention to the application development lifecycle, offer improved usability and portability. These extensions (including versioning and deployment...
EU07A08.flv