Abstracts and Biographies (scroll down)

 

Performance Topics for DB2 Application Coders

Sheryl Larson

Abstract:

Efficient coding techniques that turn DB2 data into precious information will be demonstrated throughout the presentation.

Powerful techniques from DB2 V1 through DB2 X will be provided; topics like data warehouse queries, refining summaries,

table pivoting, and many more.

 

     Objective1: Demonstrate what is the best SQL for Data Warehouse Queries

     Objective2: Demonstrate the most efficient SQL for Refining Summaries

     Objective3: Demonstrate the most efficient SQL for Table Pivoting

     Objective4: Demonstrate the most efficient SQL for Finding the Needle in the Haystack

     Objective5: Demonstrate the most efficient SQL for Calculating Gaps in Column Values (any data type)

Bio:

Sheryl M. Larsen is an internationally recognized researcher, consultant, lecturer, specializing in DB2, and owns

Sheryl M. Larsen, Inc. (www.smlsql.com), a firm specializing in Advanced DB2 Consulting and Education. She is known

for her extensive expertise in SQL and performs detailed DB2 Performance Health Checks for many clients. Sheryl has

over 20 years experience in DB2, has published many articles, and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999.

She was voted into IBMÕs inaugural Information Champion program 2009 - 2010, the IDUG ÒSpeaker Hall of FameÓ in 2001

and is a member of IBMÕs DB2 Gold Consultants program.

 

 

Integrated Data Management: Product Strategy and Vision

Curt Cotner

Abstract:

This presentation provides an overview of the IBM Integrated Data Management portfolio of products,

along with a roadmap for future deliverables and the long-term product vision. The presentation covers

all aspects of data and application life-cycle management that are addressed by

the Integrated Data Management portfolio of products.

Objective:

Develop an understanding of IBM Integrated Data Management

Understand the market drivers behind Integrated Data Management

Understand the vision of Integrated Data Management

Understand how IBM Optim and Data Studio solutions support Integrated Data Management

Get a sneak peek of future portfolio enhancements

 

 

Optimizing your WebSphere applications with Data Studio

Curt Cotner

Abstract:

Describe benefits of pureQuery Technology

Discuss WS Application Server end-to-end elapsed time monitoring

Discuss how DBAs can manage WAS connections

Abstract:

This session describes the features of IBM Integrated Data Management that allow customers to optimize

the performance, monitoring and administration of applications that run under IBM WebSphere.

 

 

Benefits of the new Native SQL Stored Procedures (DB2 for z/OS)

Philip Czachorowski

Abstract:

The new DB2 Version 9 native SQL stored procedures execute within the

DB2 engine and offer the benefits of being zIIP eligible and reduced

development effort. This presentation will describe the SQL PL language

elements and performance characteristics, comparing native SQL stored

procedures to external SQL and COBOL external stored procedures. It will

summarize the advantages and disadvantages of native SQL SP and provide

usage guidelines.

- DB2 stored procedure options

- SQL PL language overview - based on the SQL/PSM standard

- Error processing and debugging

- Performance characteristics of SQL PL

- Comparison of native SQL stored procedures to external SQL and COBOL stored procedures

- Usage recommendations