|
The first quarter 2005 Colorado DB2 Users Group for z/OS will be held on March 17, 2005
at FedEx. The following is a list of the presentations:
Introductory Remarks
Mike Skaff, First Data Corporation - President of the User Group
Click here for opening remarks
Click for meeting and registration details
Technical Session A:
Randy Ebersole, IBM – Senior IT Specialist DB2 UDB for z/OS
Let’s Look at Materialized Query Tables for DB2 V8 z/OS
It is very common that as the amount of data grows in our DB2 tables and as our applications become more complex,
queries must run against a large amount of data. Even though the amount of data has increased, there are still business
requirements to deliver response times as quickly as possible. Materialized query tables are very effective in working
with data warehousing applications. This presentation will discuss the basics of materialized query tables and give you an
understanding of how you can best utilize this new functionality in DB2 V8.
Randy is a Senior IT Specialist in IBM's Information Management DB2 for z/OS Services organization. Randy provides
onsite technical consulting to customers around the world. With more than 18 years of DB2 experience, Randy has expertise
in database and application design, performance and high availability.
Click here for a PDF copy of this presentation.
Technical Session B:
Steen Rasmussen, Computer Associates – Sr. Consultant
V8 Table Partitioning - the Good, the Bad and the Ugly
V8 delivers a wealth of new features making it easier to maintain and limit the outage for partitioned objects.
At the same time, V8 introduces a complete new way of thinking, so before exploiting V8 partitioning changes,
it's necessary to understand the impact in order to stay in control. This presentation covers all the new
features using real life scenarios and provides a list of issues to consider to be prepared.
Steen started in 1982 in Operations at Ford Motor Co. Continued as a developer for another 2 years until he
became an IMS and DB2 DBA at an insurance company in Denmark. Participated in all aspects within DB2 from
implementing DB2 Version 1.0 back in 1986. Performed tuning, design, education, automation processes until 1995.
For three years he was a member of the DB2 GUIDE Nordic region as well. Assisted in starting up the Danish PLATINUM
technology operation, where he was the Technical Manager. Job content was technical support, presales support for the
DB2-tools suite and education of the customers. From 1999 when CA acquired PLATINUM, he has continued to present
solutions to customers, assisted customers to utilize the DB2-tools suite in order for the customer to get “value for
the money”. The last couple of years have been spent in DB2-development of Computer Associates - providing ad-hoc
support for internal DB2 consultants, assisting customers in utilizing our DB2-tools, assisting development in future
development regarding exploitation of DB2 features. Lately more time is being spent doing seminars on new V8 features
based on experiences and benchmarks
Click here for a PDF copy of this presentation.
DB2 Version 08 Update
Kevin Harrison, IBM - West Region Technical Sales Support for DB2 zSeries
Update from IBM on DB2 Version 08.
Click here for a PDF copy of this presentation.
Technical Session C:
Bob Leedom, FedEx Freight System – Sr. Database Administrator
Rob Crane, FedEx Freight System – Sr. Database Administrator
Mile High DR – Things I wish I had been told
Explore the internals of FedEx Freight’s DB2 Disaster Recovery procedures and methodologies. Learn from experiences
we have had recovering our system and user data during DR exercises at IBM testing facilities. Gain valuable insight
into how to best automate your DR to achieve your business goals. Obtain real life examples and learn of pitfalls
without losing sleep! Get the critical factors that will make your own DR a success.
Bob received his MIS Degree from Messiah College, 1986. Accepted a position as a SQL/DS programmer with Book-of-the-
Month Club in 1986. Moved into a DBA position with them in 1990 and worked on converting from a VSAM shop to a DB2
shop. Converted shop from plans to completely packages. In 2000 took a brief tour of duty with MCI/Worldcom as a
contractor Senior DBA. Then in 2003 began working for FedEx Freight System as a Senior DBA.
Rob received his MIS Degree from UNI, May 1990. Accepted a Programmer/Analyst position with State Farm in 1990.
Programmed against DB2 using PL/1, Cobol, REXX and Smalltalk. Converted their Billing and Client systems from
IMS DB to DB2. Became a primary contact for the Client system including; modeling, coding and application DBA work.
Joined The Principal as a DBA and team lead in 1995. Responsible for application and subsystem tuning, backup and
recovery, object maintenance, and security. Co-chaired DB2 training and standards projects. Joined Platinum Technology
as a Senior DBA in July 1998. Working on-site at EDS/MCI supporting CA's DB2 OS/390 products and assisting EDS with
their DB2 efforts until July 2004. Joined FedEx Freight System as a Sr. DBA in July 2004! Working on an awesome DBA
team supporting all aspects of DB2. IBM Certified Solutions Expert - DB2 V7.1 & V8.1 Database Administration for OS/390
& DB2 UDB or z/OS.
Click here for a PDF copy of this presentation.
Technical Session D:
Brad Clevinger, EDS – Database Administrator
DB2 Application Tuning 101: The Nuts and Bolts
Application Tuning is a critical activity for the DBAs and Developers. Together, these two staff members can
identify inefficient SQL and tune the SQL so that it executes quickly/efficiently as to prevent i/o bottlenecks,
cpu monopolization or internal DB2 resource bottlenecks. This presentation reviews the how to, the steps involved
and the key items the DBA/Developer should look for during Application Tuning process.
Brad has over 19 years experience with DB2 starting with Version 1.0. He has been a both DBA and Developer. He has
worked for MCI, Sprint, GTE, Nevada Bell, BellSouth and now with EDS. Brad's focus has been DB2 Application Support
and Tuning. He is an IBM Certified Solutions Expert - DB2 UDB V7.1 Database Administration for OS/390 and also an
Oracle 9i & 8i Certified Professional Database Administrator.
Click here for a copy of this presentation.
|
Colorado DB2 Users Group For z/OS