|
The Colorado DB2 Users Group for z/OS meeting will be held on March 16, 2006 at FedEx.
The following is a list of the presentations:
Introductory Remarks
Rob Crane, FedEx Freight - President of the User Group
Click for meeting and registration details
Technical Session A:
Steen Rasmussen, Computer Associates
Exploiting the Log's Many Possibilities
The log is a vital part of DB2 and DB2 recovery. However - once you start to exploit the content, many day to
day tasks can be changed for the better for everyone. This presentation will look into real life scenarios how
DB2 sites are squeezing the most out of the log to manage audit control, application recovery, change propagation,
application QA and assisting in disaster scenarios.
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.
Technical Session B:
Willie Favero, IBM
UDB DB2 for z/OS V8 Planning
The best way to protect your DB2 for z/OS investment is to aggressively prepare for the next release. Just
because migrating to DB2 for z/OS Version 8 may only be a dream today, that is no reason to put off the planning
and preparation for your almost guaranteed move to you will have to make to Version 8 tomorrow. There are lots of
things you can do today to get ready for that eventual migration tomorrow. This presentation will review and
discuss the task available while on Version 7 (or before) so you are in the right shape to do a Version 8 migration.
Click here for a copy of this presentation.
IBM DB2 Update, z/OS architecture (zIIP, zAAP, IFL)
Kevin Harrison, IBM - West Region Technical Sales Support for DB2 zSeries
Kevin Harrison is a Certified Senior I/T Architect with broad experience in application development, database
management systems, architecture development, technical infrastructures, and system integration. He is
responsible for pre/post sales technical consulting for DB2 on zSeries in the West region. Kevin draws on
a wide range of experience from 23 years of involvement with DB2 on large systems, with 17 of those years
at IBM as a DB2 technical specialist. Kevin has served as a DB2 educator, led many DB2 design/implementation
reviews, and DB2/zSeries performance and tuning engagements. Kevin serves as an IBM liaison to several
regional DB2 user groups. Kevin is certified in several disciplines for DB2 on z/OS and currently is a member
of the IBM North American I/T Architect Certification board, IBM zChampions, IBM Americas Data Management
technical competency, and the DB2 for z/OS Performance review board.
Click here for a copy of this presentation.
Technical Session C:
Willie Favero, IBM
The Good, the Bad and the really Ugly: DSNZPARM
Yes, it’s back again, another discussion on DSNZPARM. Although it has the same title, this presentation has
all new information. A few of the original items are still discussed but most of the information delivered is
new. This presentation will examine the hidden, not so hidden (opaque), and visible ZPARMs. It will discuss
parms that might affect your V8 migration and new to V8. If you give this presentation a listen, you will leave
with the ability to separate the facts from the fiction the next time someone speaks ZPARM to you.
Click here for a copy of this presentation.
Technical Session D:
Rob Crane, FedEx Freight System
A Nuts and Bolts Approach to Plans and Packages
01. Program Preparation
a. Understanding the Big Picture (Compile, Precompile, Bind, Link, Execute)
b. Precompile process described in detail
c. Bind process explained in detail with performance suggestions; all package bind options discussed in detail
d. Relationship between plans, collections and packages discussed in detail with numerous examples
e. Explain process with Optimization Hints described in detail, as well as a discussion on reoptimization
02. Package Execution Flow and System & Catalog Table Overview
a. Review DSNDB01 & DSNDB06 tables and purpose
b. Review of the skeleton cursor and package tables
c. Package execution flow
d. V8 updates and enhancements
03. Recommendations for Implementing and Maintaining
a. How many plans and collections should we implement?
b. Naming standards - vendor packages – performance
c. Standards for package and PLAN_TABLE clean up
04. Advanced Package Topics & Problem Resolution
a. SET CURRENT PACKAGESET & PACKAGE PATH with stored procedure package detail
b. Java & SQLJ package deployment
c. Read only package implementations
d. Deprecating obsolete packages
e. What makes a package invalid and inoperative?
f. Consistency token investigation, solve your –805s
g. Rebind considerations for stored procedures and triggers
h. Security options (BINDAGENT, PACKADM, etc.)
05. SQL statements to view plans, collections and packages, along with security reference material
useful in solving authority issues with plans and packages
Biography:
Rob Crane
MIS Degree, University of Northern Iowa, Cedar Falls, IA May 1990. Accepted a Programmer/Analyst position with
State Farm in 1990. Programmed against DB2 using PL/1, Cobol, REXX and Smalltalk. Converted monthly 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 Sr. DBA in July 1998. Worked on-site at MCI/EDS supporting Computer Associates’ DB2
products and assisting EDS with their North American DB2 efforts until July 2004. Joined FedEx Freight System as a
Sr. DBA in July 2004. Working on a DBA team supporting all aspects of DB2 and Oracle. IBM Certified DBA in both V7.1
DB2 UDB for OS/390 & V8.1 DB2 UDB for z/OS. Co-founder and VP of CDUG (www.coloradodb2rug.org). Fortunate to be
selected as a user speaker for IDUG North America conferences 2000-2006. Fortunate to receive top 10 honors in 2000
& 2005 and Best User Speaker honors in 2005 (North America & Europe).
Click here for a copy of this presentation.
|
Colorado DB2 Users Group For z/OS