MDUG Seminar

Date: September 17, 2009

Hotel: Baronette Hotel (Novi)

Seminar Program

Presentation Abstracts

DB2 9 supports native XML, which means that you can deal with an XML data type as opposed to just storing XML in mechanisms such as large objects. During this presentation, you will learn the steps needed to connect to DB2 9, create objects, and manipulate data.

Database Administrators should be used to information technology standards by now. Where ITIL differs is it not a database or operating system standard it is a process management standard. ITIL is an integrated set of best-practice recommendations that uses common definitions and terminology. Where does the DBA role fit into this process management standard?

DB2 z/OS V8 and 9 have introduced us to many new EXPLAIN tables. This session will introduce users some of the new EXPLAIN tables to be used for advanced query analysis, and demonstrate how SQL queries can be used to gather and analyze this information. The session will also include information about using the DSN_STATEMENT_CACHE_TABLE to perform analysis on the dynamic SQL cache.

This presentation will look at some of the performance features in V8 and how they have been successfully used in our applications and databases to meet some of our current performance challenges. Those challenges, of course, being performance and availability. We will discuss some of the things we still desire in terms of application and database performance and take a look at V9 to see what features are available to further improve our performance and availability of our applications. We will look at how we may take advantage of those features.

IBM® InfoSphere Warehouse makes it easier to discover business opportunities hidden in your data. It provides a comprehensive platform to design, optimize, and grow departmental data marts and enterprise data warehouses. InfoSphere Warehouse extends the DB2 platform with integrated functionality and tooling that delivers superior scalability and availability, comprehensive design, build, and management tooling, and business analytics. The presentation will cover the key enhancements delivered in the latest release, Version 9.7.

Speaker Biographies

Mike Sniezek career in Information Technology began in 1976 and is currently a Senior Product Manager with BMC Software. He has worked with relational technology since 1984, specializing in database technology as a consultant and lecturer. Mike has presented at International and local conferences topics related to relational database architecture, distributed technology and the Internet.

Susan Lawson is an internationally recognized consultant and lecturer with a strong background in system and database administration. She currently works with several large clients to help development, implement and tune some of the world’s largest and most complex DB2 databases and applications. She also performs Performance Audits for many clients to help reduce costs through proper performance tuning. Her other activities have included authoring articles, presenting at user group meetings, and authoring white papers. She is an IBM GOLD Consultant for DB2 and z/Series, and has authored the IBM ‘DB2 for z/OS V8 DBA Certification Guide’, DB2 for z/OS V7 Application Programming Certification Guide’ and ‘DB2 9 for z/OS DBA Certification Guide’. She is also the co-author of several DB2 books including ‘DB2 High Performance Design and Tuning’ and ‘DB2 Answers’.

John Sheppard is a Senior IT Specialist with IBM Information Management, located in the Detroit area. John has 20 plus year of IT experience and is a member of IBM's BI Best Practice Team. He also serves as a member of MDUG board of directors.