MDUG Seminar

Date: Thursday, June 17, 2010

Location: The Baronette Renaissance (The Hotel Baronette), Novi Michigan

Seminar Program

Seminar Program

Presentation Abstracts

Hear the latest updates on system and application performance on IBM DB2 9 and DB2 10 Beta for System z. The session focuses on getting the most out of DB2 9 for z/OS performance. Both system-level and application-level of performance tuning and considerations in the area of high interest is covered, such as updates on general performance enhancements in Version 8 and 9, considerations on Version 9 upgrades, updates on open/close datasets, data/index compression, SQL procedures, synergy with IBM System z Hardware and DB2 pureXML performance.

IBM DB2 for z/OS has provided data compression for several versions now. With DB2 9 for z/OS, you can also compress your indexes and DB2 10 for z/OS Beta takes this further. This can result in significant reductions in your disk consumption. In this session, you will hear about the history of compression, get a detailed description of data compression and index compression, learn about monitoring the effectiveness of compression, and receive some hint and tips about when to take advantage of the different compression types available in DB2.

DB2 pureScale is a DB2 feature that reduces the risk and cost of business growth by providing unlimited capacity, continuous availability, and application transparency. It allows you to have multiple database servers in a system that all share a common set of disks. This session will discuss DB2 pureScale, its architecture, unlimited capacity, and more.

DB2 9.7 is the latest DB2 release on the Linux, UNIX, and Windows (LUW) platforms and provides exciting new technology. This session will discuss upgrading to DB2 9.7 for LUW from previous versions of DB2 LUW and will point out and discuss areas to be aware of and prepare for as well as listing many of the changes that you need to be aware of before and after an upgrade to DB2 9.7.

 

Speaker Biographies

Rafael Garcia (IBM Corporation)

Rafael Garcia is a DB2 Technical Specialist with IBM Corporation. He works with IBM customers as a member of the DB2 z/OS Customer Relationship Development team managed out of the DB2 z/OS Silicon Valley Lab. Rafael is based in south Florida.

Bob Harbus (IBM Corporation)

Bob Harbus has been with IBM since 1989 and with the IBM Toronto Lab since 1992. Bob has worked in a number of areas including DB2 Linux, UNIX, Windows development, DB2 Service, DB2 Certification (where he authored a number of books on DB2) and DB2 Lab Services (specializing in data warehousing). He is currently a DB2 Evangelist and member of the Worldwide DB2 Evangelist team out of the IBM Toronto Lab. Bob meets with customer's worldwide discussing DB2 technology.