Optimizing DB2 performance with BMC's SQL Performance for DB2 Solution

Andy Laredo, BMC

Abstract:

This presentation will show how advanced solution features can help you solve tough performance

problems. We'll look at APPTUNE statement analysis - how to identify and then fix performance problems.

We'll also explore recent improvements to APPTUNE, including the new Time Interval capability. Next,

we'll take a closer look at the Index Analysis component and show you the Clone Index feature you can

use to create, analyze, and test a new index. Finally, we look at how the Workload Compare can compare

a new application release before it is released to production! Other examples will show how this feature

can compare a workload on one version of DB2 to another DB2 version

Biography:

Andy Laredo has 30 years of mainframe computing experience, with extensive work in IMS, DB2, and z/OS.

As a DB2 user, Andy's roles included DBA and application development responsibilities. In the data base

software industry he has been a product architect and developer. Mr. Laredo has been a DB2 software

consultant with BMC for 10 years, covering the Northeastern United States. In this capacity, he consults

with BMCÕs DB2 customers on BMC products and strategies.

 

 

The Clones Have Landed Ð Watch Out !

Steen Rasmussen, CA

Abstract:

This presentation will describe the possibilities and limitations exploiting Cloned tables in DB2 9 for z/OS.

The new SQL syntax and statements associated with Cloned Tables will be covered by using a live DB2 9 system

and real data to illustrate the changes. Since some Utilities operate on the table/index level and some operate

on the tablespace level Ð the impact on each Utility will be covered as well as the new keywords and commands Ð

again by using a live DB2 environment to illustrate the implications.

Finally - the catalog changes and new parameters will be covered when utilizing Cloned tables.

     - What is a Cloned Table, where can it be useful and what are the limitations

     - DDL Syntax Changes and SQL impact exploiting Cloned tables

     - Utility changes and considerations when executing utilities against Cloned tables

     - Catalog Changes including attributes when utilizing Cloned tables

     - Recommendations and experiences based on a case study using Cloned tables

Biography:

Steen Rasmussen is a Sr. Engineering Services Architect currently instrumental in the ongoing development

and support of the CA DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark

working with all aspects of DB2 - like tuning, application design and implementation, education of developers,

backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member

of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM

Technology managing technical support and presales for the DB2 products.

Steen has been working with DB2 for more than 23 years starting with DB2 Release 1.0 and is always looking for new

opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing

support for the teams in the field as well as internal groups working with DB2, Steen also is a frequent speaker at

IDUG in North America and Europe as well as local DB2 User Groups around the world

 

 

To Log or Not to Log - please don't dig yourself a too deep hole.

Steen Rasmussen, CA

Abstract:

The attendee will get an A-Z walk through of the DB2 9 NOT LOGGED tablespaces feature and what the impact is for

applications as well as for backup / recovery and change propagation. The presentation will also describe the

performance impact for SQL statements when NOT LOGGED is used compared to logged tablespaces.

     1) DDL changes implementing Not Logged tablespaces

     2) Impact on applications and SQL when dealing with Not Logged tablespaces

     3) Backup and recovery considerations

     4) Performance case study

     5) Recommendations based on usage and performance

Biography:

Steen Rasmussen is a Sr. Engineering Services Architect currently instrumental in the ongoing development

and support of the CA DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark

working with all aspects of DB2 - like tuning, application design and implementation, education of developers,

backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member

of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM

Technology managing technical support and presales for the DB2 products.

Steen has been working with DB2 for more than 23 years starting with DB2 Release 1.0 and is always looking for new

opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing

support for the teams in the field as well as internal groups working with DB2, Steen also is a frequent speaker at

IDUG in North America and Europe as well as local DB2 User Groups around the world

 

 

Predicting Performance Changes - in a timely manner

Steen Rasmussen, CA

Abstract:

The attendee will get a quick overview of Explain Ð the benefits and limitations as

well as some historical information. We will look at some scenarios where we really need to establish a PROACTIVE

approach in terms of being prepared for performance changes ahead of time Ð but also look at how a REACTICE approach

sometimes is even more important. Part of this presentation will be a live walk thru of how to accomplish these

goals using CA Plan Analyzer.

Biography:

Steen Rasmussen is a Sr. Engineering Services Architect currently instrumental in the ongoing development

and support of the CA DB2 tools. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark

working with all aspects of DB2 - like tuning, application design and implementation, education of developers,

backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member

of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM

Technology managing technical support and presales for the DB2 products.

Steen has been working with DB2 for more than 23 years starting with DB2 Release 1.0 and is always looking for new

opportunities in the CA DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing

support for the teams in the field as well as internal groups working with DB2, Steen also is a frequent speaker at

IDUG in North America and Europe as well as local DB2 User Groups around the world

 

 

Performance Prediction for DB2 Upgrades to DB2 z/OS V9

Hussaina Husain, IBM

Abstract:

Are you looking to eliminate costly surprises and avoid unexpected results from bind operations? Do you want to

predict whether a bind will result in a changed access path? DO you want to reduce your I/T staff's time of manually

analyzing and reviewing SQL statements of new and modified applications to determine whether or not an access path

will change? .Do you want to have a smoother migration from DB2 version to version by proactively identify potentially

harmful access path changes before they occur? DO you want to establish a base line to identify possible high-risk

access path changes by automatically populating PLAN_TABLES without having to initiate bind/rebind?

IBM DB2 Path Checker tool is the answer to all of the above questions. It automates the process of proactively

identifying which SQL statements would result in access path changes from a bind or rebind request.

Biography:

Hussaina Husain is a Certified Consulting IT Specialist on the North America IBM z/Series Database Tools Team,

covering East Region. Hussaina's expertise is in DB2 data base tools arena with a specialization in DB2

performance/tuning and Recovery Solutions.

Hussaina has over 30 years I/T experience, 7 of which have been at IBM in the technical sales specialist role.

Prior to IBM her experience was as a consultant working as a Systems Programmer and DBA for DB2, IMS and CICS

in many different capacities and in a variety of different industries. Primary areas of expertise were DB2/IMS

database design, Monitoring/tuning systems and databases for cost/performance efficiency.

Hussaina is a Certified DB2 for z/OS V9 System Administrator and DB2 for z/OS V8 Database Administrator, and has

presented at IDUG, the DB2 Technical Conference and at local DB2 user groups.

 

 

Demystifying the Dynamic SQL Statement Cache

Bill Arledge, BMC

Abstract:

Dynamic SQL is being used more and more in DB2 shops around the world. Multiple factors are driving this increase

in usage. As with most DB2 options, dynamic SQL offers potential benefits as well as new management challenges.

This technical session begins with a brief overview on SQL tuning followed by a more detailed discussion on managing

and tuning the dynamic statement cache, a DB2 feature that helps address dynamic SQL performance issues. WeÕll discuss

enabling and effectively utilizing the cache, from bind parameters to system considerations to mining the performance

data available from the cache. WeÕll also look at the evolution of features in DB2 V8, 9, and potential future enhancements

that will improve your ability to leverage the dynamic statement cache for greater benefit.

Biography:

Bill Arledge is an IT veteran with 34 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