• IBM presentation pens
• IBM books
• IDUG 2005 flash drives
• IDUG 2005 Conference proceedings CD

DB2 for z/OS V8
Platform: DB2 for z/OS - Audience: All

Learn about DB2 for z/OS from the master.

Roger Miller works out of the IBM Silicon Valley Lab [DB2 for z/OS lab] in San Jose, California. Roger [also known as Mr. DB2 to some] has worked for more than a quarter of a century on DB2 development, product design and strategy. He often helps customers to use the product, answers many questions and presents frequently at user groups and conferences. He was a customer for ten years before working on many facets of DB2 including overall design of DB2 releases, SQL language, install, security, audit, standards, performance, concurrency, and availability. We sometimes call Roger a jack of all DB2 trades and a master of several. Roger’s favorite response is: “IT DEPENDS!”

Make the most of your DB2 Connect system
Platform: DB2 Cross Platform - Audience: All

DB2 Connect is employed by almost every DB2 for z/OS shop, yet most installations use only a subset of its features. This session will highlight and explain more advanced features of the DB2 Connect system. These features will help you achieve higher levels of availability, better workload management and higher performance. DB2 Connect can also bring you in to the world of SOA [system oriented architecture] and web services and mobile computing.

Leon Katsnelson title is Program Director, Competitive Technology for IBM at the IBM Toronto Lab. He is a recognized expert in the areas of DB2 Application Development and DB2 Connect [also known as Mr. DB2 CONNECT to some!]. Leon has 21 years of experience with complex database and network systems. Over the years he has helped many customers to integrate DB2 into their solutions. Leon frequently presents his experiences at user group meetings and industry conferences.

Performance Toolbox: 10 Scripts for Faster Systems
Platform: DB2 for Linux, Unix, Windows - Audience: All

It can be difficult to recall and apply performance tuning rules you've seen in print or at a conference. In this session, we review many of these techniques, and then we describe and demonstrate a set of free, portable and easy-to-use sample scripts for performance monitoring. These scripts simplify monitoring of areas like bufferpools, locking, SQL, etc., and can be used as-is, or as a basis for further customization.

How Big is Big Enough? A Primer on Sizing OLTP Systems on DB2 For Linux, UNIX, Windows
Platform: DB2 for Linux, Unix, Windows - Audience: All

You're planning a new DB2 system - how much CPU, memory and disk it will need? Estimating accurately will give you the best return on your investment, but estimating poorly can get your project off to a rocky start. We will look at ways to make your DB2 sizings more accurate, such as by focusing on your system's high-impact aspects, factoring in published benchmarks, reducing sources of error and microbenchmarking.

Steve Rees joined the IBM Toronto Laboratory in 1991. He was involved with the establishment of the workstation database mission in Toronto as well as several releases of DB2 for LUW product development [first in the area of precompilers and then in the DB2 Unix porting team]. Steve is currently a senior technical manager in the DB2 performance organization with responsibility for the performance of Java data access, Linux OLTP and SAP. He is a frequent speaker at user groups and conferences.

Developing SQL procedures
Platform: DB2 for Linux, Unix, Windows - Audience: All

If you are a DBA or a programmer short on time to implement applications, needing an SQL scripting language, or who wants to boost the performance of applications, then SQL PL and SQL routines may be the answer. This presentation covers SQL PL, SQL procedures, and SQL UDFs including SQL PL language elements, execution model, designing, developing, debugging, deploying, and improving performance with examples.

Gwyneth Evans is a software developer in the DB2 Solution team at the IBM Toronto Lab where she is dedicated to ensuring that customers are exploiting new DB2 features and getting the most out of them. She has previously worked in the DB2 SQL Compiler Team and as a database application developer. She is an IBM Certified Application Developer and Database Administrator, who has taught 2 DB2 Educational Seminars, presented at user groups as well as past IDUG and DB2 Information Management conferences, and regularly contributes articles and tutorials to DB2 developerWorks.

Native XML Support in DB2 Viper
Platform: DB2 for Linux, Unix, Windows - Audience: All

You may have seen the press reports about native XML in DB2 Viper. This presentation will give you an early look into what will be available in DB2 Viper to support the storage, management, and searching of XML data using DB2. Get a head start on thinking about how you can seamlessly integrate XML with your existing relational data, exploit both tabular and hierarchical data models, and enjoy the flexibility of using both SQL and XQuery in your applications.

Rick Swagerman has been in the IBM Toronto Lab since 1982. His early years were spent developing tools to interface with DB2, first on MVS, followed by VM, and then OS/2. Since 1991, he has worked as a Language Architect on DB2, primarily for LUW but also working across the DB2 family and contributing to the ANSI/ISO SQL standards. Most of the past 15 years was spent with SQL, contributing to this growing language that went from a 200 page reference to around 1600 pages. Rick's focus for the past couple of years has been on integrating XML into DB2 through SQL and the introduction of XQuery into DB2.