Abstracts and Biographies (scroll down)

 

Optimizing SQL Performance with BMC's SQL Performance for DB2

Bill Arledge, BMC

Abstract:

Biography:

Bill Arledge is an IT veteran with 33 years experience across a variety of roles, including application

development and database administration. Bill’s database experience began in the late 1970’s as an IMS DBA

and developer. He began working with DB2 in 1984 as a database specialist at IBM. He worked with DB2

throughout the late eighties, consulting with numerous IBM customers on existing and planned DB2

implementations. Bill joined BMC in 1990 and is currently a technical product manager responsible for

BMC’s DB2 data management products. In that capacity he consults extensively with BMC DB2 customers

and works closely with BMC’s Research and Development organization to drive product direction.

 

 

DB2 for z/OS: Staying Out of a Jam with Recovery AssuranceExpert

Michael Figaro, Neon

Abstract:

Are you certain you can recover your DB2 tables quickly?

Are you certain you can recover your tables at all? Sure you are, right?

With Recovery AssuranceExpert™ you can make those assertions with greater conviction.

You and your management can both sleep better.

In this session we will explore the following:

1. RTOs(Recovery Time Objectives) and why there are important.

2. Threats, subtle and not so subtle, to your ability to recover DB2 objects.

3. Surprising threats you may never have thought of, and the list keeps growing…

4. Using Recovery AssuranceExpert™ to find threats and inform stakeholders.

5. Field scenarios and what we discovered.

Biography:

Michael Figaro is a DB2 Software Consultant with NEON Enterprise Software, Inc.

Michael has been working with DB2 as a SYSADM, DBA and programmer since V1.1 in 1985.

 

 

DB2 Version 9 Support for XML: What Can It Do For You?

Gregg Lippa, Themis

Abstract:

DB2 had begun to incorporate XML features prior to version 9, but has now become a real

leader in XML support. This presentation reviews the basics of XML and XPath expressions,

discusses the benefits and uses of XML in a DB2 database, and covers the XML-related

features of DB2 version 9 in detail, including the new XML data type and the DB2 functions

that support it, how it is supported in COBOL and Java programming environments, its

impact on indexing, and an overview of its support for validation. If you are considering

using XML in your DB2 environment, this session will give you an understanding of the

potential benefits and pitfalls and a great jumpstart to understanding what is available in DB2.

Topics Include:

     * XML Overview

     * XML vs Relational Model

     * DB2's pureXML

           - What is it?

           - Why use it?

     * New XML data type

     * Indexes on XML data

     * XPath

           - What are XPath expressions?

           - Types of XPath expressions

           - Types of XPath nodes

           - XPath functions

     * DB2's XML publishing functions

     * CRUD with XML

     * Programming Language Support for DB2 XML

           - Java/JDBC

           - COBOL

     * XML features in LOAD and UNLOAD utilities

     * XML Schema Repository (XSR) and Validation

Biography:

Gregg Lippa is currently a Senior Technical Advisor at Themis Inc. He teaches DB2-related

courses on SQL, Application Programming, and optimization, performance and tuning as well

as Java, J2EE, distributed computing and Java-related topics. Gregg has worked with DB2 as

a consultant and trainer for over 20 years and with Java for 10 years.

 

 

Abstract:

Biography: