|
The Colorado DB2 Users Group for z/OS meeting will be held on April 19, 2007 at Verizon Business.
The following is a list of the presentations:
Introductory Remarks
Rob Crane, FedEx Freight - President of the User Group
How to be a Hero by taking small steps
Steen Rasmussen, Computer Associates
This presentation will describe the performance impact experienced by making small changes to both the application as
well as the physical design in a real life scenario. Issues like UR and lock avoidance will be covered and the
considerations for choosing UR. Referential Integrity is used in many applications, but is it really necessary and
what is the performance impact. Dynamic statements is becoming more and more "popular" - but should they be coded
using constants and literals - or ? Another topic which can improve performance is compression - but what is
the impact and what about the old "myths". Finally the necessity of reorganizations is being discussed and how to avoid some
these reorganizations
Steen Rasmussen is currently instrumental in the ongoing development and support of CA DB2 tools and features. In
1985 Steen started as an IMS/DB2 DBA at a major insurance company working with all aspects of DB2-like tuning,
design and implementation, education of developers, backup and recovery planning, and automation of housekeeping
processes. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and
presales for the DB2 products.
Click here for a copy of this presentation.
Attack of the DB2 for z/OS Clones - Clone Tables that is!
John Lyle, IBM
In V9 DB2 for z/OS introduces Clone Tables which gives DB2 for z/OS an Online Load Replace type of capability.
In this presentation I will introduce the concept of Clone Tables and detail how they work. Clone Tables have
several dependencies on other new V9 functionality and I will briefly go over what these dependencies are. I
will then indicate how you create Clone Tables, how data is put into a clone tables, and how the data is
magically 'exchanged' between the parent/base table and it's clone. I'll then finish up with a discussion of
how Clone Tables can be used in a customer environment.
Bullet Points:
. Rationale and description
. DDL statements
. Authorization
. Catalog and directory changes
. Commands and utilities
. Summary and future directions
John Lyle has worked for IBM at the Silicon Valley Laboratory in the DB2 organization since 1985. Joining
DB2 development in 1995, he has worked in the RDS area focusing mostly on the DB2 system catalog, migration and
fallback and the data definitional language (DDL) areas. He was the lead designer and implementer of the catalog
changes for V5 - V8, the fallback coordinator for V5 - V7 and has worked on numerous other Line Items in these
releases. He has worked in the index manager component and is currently working in DB2's Utility department. John
was the Line Item owner for DB2 9's Clone table function.
Click here for a copy of this presentation.
DB2 UDB for z/OS Indexes - An insiders look
John Lyle, IBM
This presentation will introduce DB2 UDB indexes. After a brief description the different index types, this
presentation will detail the indexing enhancements that are available with DB2 UDB V8 and V9. This includes
varying length indexes, indexes with long keys, data-partitioned secondary indexes, table controlled
partitioning, etc. Will cover catalog indexes and how they change during migrations and the V8 ENFM process.
New DB2 9 functionality will also be presented.
Bullet Points:
. Index partitioning enhancements
. True varying-length index keys
. Long index keys
. Schema changes with an emphasis on altering indexes
. V9 enhancements
. Summary
John Lyle has worked for IBM at the Silicon Valley Laboratory in the DB2 organization since 1985. Joining
DB2 development in 1995, he has worked in the RDS area focusing mostly on the DB2 system catalog, migration and
fallback and the data definitional language (DDL) areas. He was the lead designer and implementer of the catalog
changes for V5 - V8, the fallback coordinator for V5 - V7 and has worked on numerous other Line Items in these
releases. He has worked in the index manager component and is currently working in DB2's Utility department. John
was the Line Item owner for DB2 9's Clone table function.
Click here for a copy of this presentation.
Put a smile on your DBAs face Performance for the Developer (and you know-it-all DBAs)
Marc Costa, Rob Crane, FedEx Freight
Who is responsible for performance? No, not the wizard behind the curtain. Is it the application developers?
How about the DBAs? Maybe both? Hopefully the answer is not “What is performance?”. In this presentation, we
will explore simple things most shops have probably experienced or are currently experiencing with performance.
We will discuss easy ways to spot performance issues in development before they become production nightmares. We
will cover clustering, indexing and the importance of the 3 R’s (runstats, reorg, rebind) when analyzing
performance issues. We will look at ways to efficiently ask common questions of the database (does this row
exist, does this column add filtering to the index, etc.). Come away with an understanding of performance pitfalls
and how to avoid them in your shop. Understanding your data and how DB2 sees it.
Clustering concepts and impacts on your SQL performance. Why clustering matters. What caused list prefetch to
kick in? What is prefetch anyway and should I care if it changed?
Is there more than one way to do an existence check? Get off my case, my visual explain says I am using an index!
Did you check the cardinality of that index? Visual explain shows I am only joining two tables together in my online
transaction, it can’t take that long can it?
Is multiple index access similar to multiple personality disorder? Who is this Cartesian guy? Should I worry about
him? I used LIKE because the user does not know what they want, why should I be concerned with re-optimization?
Runstats... Bueller? Reorg... Bueller? Rebind... Bueller? Anyone? Statistics rule, opthints drool. What can I do
with real-time statistics? What is stats advisor? My drain is stuck, got any drano?
Marc Costa BSBA Degree, Colorado State University, Fort Collins, CO December 1993. Accepted a Programmer position
with Mutual of Omaha in 1994. Programmed against DB2 using Cobol and Visual Basic. Accepted a position as an application
DBA, September 1998. Joined FedEx Freight System as a Sr. DBA in January 2003. Working on a DBA team supporting all aspects
of DB2, including upgrades (V7, V8), application design, SQL tuning and system tuning. IBM Certified DBA V8.1 DB2 UDB for z/OS.
Rob Crane is a database enthusiast who began programming against DB2 in 1990. He has held several roles interacting with
DB2; programming, modeling, system design, sysprog and database administrator. Gained DB2 experience working for State Farm, The
Principal, Platinum/CA and FedEx. Rob is responsible for leading FedEx Freight’s database teams, supporting all aspects of database
development. IBM Certified DBA for DB2 on z. Co-founder & chairman of www.coloradodb2rug.org. Fortunate to be selected as a user
speaker for IDUG NA conferences 2000-2007. Received top 10 speaker honors in 2000, 2005 & 2006 and Best User Speaker in 2005 (North
America & Europe). Member of the IDUG NACPC 2007 & 2008.
Click here for a copy of this presentation.
|
Colorado DB2 Users Group For z/OS