Location: Sheraton Centre Toronto
| 08:15-09:00 | REGISTRATION / CONTINENTAL BREAKFAST
| 09:00-09:10 | OPENING REMARKS - Chairperson
| 09:10 - 10:40 | DB2 RECOVERY FROM Z TO A
| Willie Favero - BMC Software 10:40 - 11:00
| COFFEE BREAK
| 11:00 - 12:00 | SQL FOR THE 21ST CENTURY
| Willie Favero - BMC Software 12:00 - 01:15
| LUNCH
| 01:15 - 02:30 | USING AUTOMATIC SUMMARY TABLES IN DB2 UDB
| Kelly Lyons - IBM Toronto Laboratory Performance Group 02:30 - 02:45
| COFFEE BREAK
| 02:45 - 03:45 | USING DB2 UDB EEE IN OLTP ENVIRONMENTS
| Fady Badra - IBM Toronto Laboratory Performance Group |
DB2 RECOVERY FROM Z TO A
Today, your data is your buiness. Too frequently though, backup and recovery tend to be an area that is overlooked,
not emphasized enough, or simply just misunderstood.
Very often, recoveries just are not performed enough to maintain the skill to run them properly.
In fact, the continued change and maturing of DB2 can make it difficult to keep up with the latest and greatest features of copy and recover.
What you sometimes need to do is just stop, step back a minute, and get back to the basics.
Questions I still hear, and some of the topics I will focus on are:
Why do I make copies?
Should I use full or incremental copies?
SHRLEVEL Change or Reference?
How frequently should I run my copies?
How big should my active logs be?
What is in SYSCOPY and SYSLGRNG and why should I care?
What about merge copy and modify, are they important and can they help me?
Can I improve the performance of the recovery process?
Is there anything new?
This presentation answers these questions and more.
It will benefit both the novice as well as the experienced DBA.
Willie Favero is a Principal Development Consultant in the Research and Development organization at BMC Software, Inc.
He has been working with database software for more than 24 years.
Willie started with IMS. However, for the last 15 years he has been working with all aspects of DB2.
Willie has authored numerous articles, contributed to several of IBM’s Redbooks, and acted as a technical editor to dozens of database, object oriented, programming, and data warehouse books.
He is a highly sought after presenter at IDUG (North America, Europe, and Asia Pacific), GUIDE, SHARE, most local DB2 User Groups, many international DB2 User Groups, and the IBM DB2 Technical Conference.
SQL FOR THE 21ST CENTURY
Remember Outer Join, Table Check Constraints, and Nested Table Expressions?
That's nothing compared to what you are going to see.
Interested in SQL3 and how DB2 is handling it?
This presentation covers all the latest advances in SQL for the DB2 family.
It discusses the history of standards from the first SQL through SQL-92, SQL3, and beyond,
what effect standards have had on past versions of DB2
and some just plain interesting things that have happened to SQL over the years.
USING AUTOMATIC SUMMARY TABLES IN DB2 UDB
In this talk, we will describe Automatic Summary Tables (ASTs) in DB2 UDB
and show how they can be used to greatly improve the performance of complex queries.
Given a fact table and dimension tables, data summaries such as sales by region can be precomputed and stored in an AST.
Queries looking for information about sales in a given region will automatically use the AST to answer the query, thus saving valuable computation time.
We will give several examples and provide helpful hints on how to decide which ASTs should be created.
USING DB2 UDB EEE IN OLTP ENVIRONMENTS
DB2 UDB EEE is a leader in decision support environments. With changes available in Version 5.2 the same outstanding performance can be brought to OLTP environments.
This talk will cover both the changes in 5.2 that make UDB suitable for OLTP in a partitioned environment, and provide configuration and tuning advice.