Database Administration for z/OS Technical Sessions  

To help you identify the content most relevant to you out of the more than 200 hours of technical education offered at IDUG 2008 - North America, the following sessions below have been selected as having particular relevance to Database Administration for z/OS include:

DB2 Foundations

• A01 Ultra-Availability – How Far Can You Go?
• A02 Performing a DB2 Checkup
• A03 DB2 System Performance, the Basics... and a Bit to a Lot More
• A04 DB2 for z/OS DB2 Database Design – Top Tips from Experience
• A05 Parallelism Strategies in the DB2 Optimizer
• A06 Breaking the DB2 Platform Barrier
• A07 DB2 for z/OS in an SOA
• A08 Utilizing Views, RI and Other Stuff for Performance
• A09 The Clones have Landed – Watch Out!
• A10 Let's Take a Walk with WebSphere Federated Server
• A11 How Much DB2 Testing is Enough? 
• A12 What is a Performance Warehouse and is It Worth It?
• A13 DB2 Partitions - How Do We Tell Them aPART?
• A14 Ready, Set, Go! Benchmarking Your DB2 System

DB2 for z/OS

• B01 Fast Track to Optimal DB2 Performance
• B02 Data Structure Design for a Continuous Availability System
• B03 Green Light, Go! Building Your Own DBA Dashboard
• B04 DB2 z/OS – Hands Free Approach to Maintenance of Multi Terabyte Tables
• B05 Optimizing DB2...Through Statistics Trace (Part 1 of 2)
• B06 Optimizing DB2...Through Statistics Trace (Part 2 of 2)
• B07 Urban Legend: Upgrade from DB2 for z/OS V7 to DB2 for z/OS V8 (NFM) In Less Than 90 days
• B08 Memory Management for Dynamic SQL
• B09 Creating Customized Tools for DB2 for z/OS
• B10 Desperate Table Designs
• B11 Mature Database Performance: Doing More with Less 
• B12 DB2 System Maintenance: Stay Flexible in an Inflexible World
• B13 The DB2 catalog - Past, Present, and Future
• B14 The Answer to: "What Happened? When? Who Did It?"

DB2 for z/OS "Cutting Edge"

• C01 DB2 for z/OS Update
• C02 High Insert Workload - A Study using DB2 z/OS V9 
• C03 DB2 9: Disaster Recovery For the Rest of Us
• C04 DB2 9 for z/OS Select, Insert, Update, Delete SQL Application Performance
• C05 LOBs: Stronger and Faster in DB2 9 for z/OS (Part 1 of 2)
• C06 LOBs: Stronger and Faster in DB2 9 for z/OS (Part 2 of 2)
• C07 DB2 Data Sharing Best Practices
• C08 Planning Your Migration to DB2 9 for z/OS
• C09 What's New in DB2 for z/OS Buffer Pool Management
• C10 Active Data Sharing for SAP at John Deere
• C11 Best Practices in DB2 Security
• C12 Structure and Format Enhancements in DB2 9
• C13 Workloads, Monitors, Advisors: V9 OSC Experiences
• C14 DB2 Stored Procedures Update

DB2 Application Development - I

• F01 SQL Optimization & Access Paths: What’s Old & New
• FO2 DB2 WebSphere Integration Best Practice
• F03 Getting More Out of Visual Explain V8
• F04 Adventures Using Triggers, Stored Procedures, and User Defined Functions
• F05 I love Packages-N-Collections; Put Another Dime in the Jukebox Baby!
• F06 Successfully Deploy SQLJ in your Business Critical Applications
• F07 Things I Wish I Hadn't Told You…
• F08 Query Tuning with Optimization Service Center
• F09 Mainframe Optimization Oscars
• F10 Leverage the Power of SQL on XML Data
• F14 DB2 z/OS Optimizer: What have you done for me lately?

DB2 Application Development - II

• G01 SOA hands on with DB2
• G02 Who Stole My Favorite Scan and Access Path?
• G03 No Magic to Improve DB2 for z/OS Application Performance
• G09 Rexx to the Rescue!
  

Experience DB2 - I

• H06 Migrating Your DR Program Into the 21st Century
• H07 CAs Log Analyzer for DB2 for z/OS - You Can Do THAT!?
• H10 IDUG Europe Premiere User Speaker: Migration of DB2 Access Control from DB2 to RACF
• H12 Build Replication in a Snap!
  

Experience DB2 - II

• I02 Data Modeling with Rational Data Architect
• I03 Monitoring SQL Performance Using the DB2 Statement Cache
• I05 IBM DB2 RUNSTATS Utility: What's Old, What's New, What's a FREQVAL?
• I06 Managing Your DB2 Maintenance – With RealTime DBAExpert
• I07 24/7 Environment, Need to Update Production Data? Audit, Data Security & SOX Compliance FEARS!!! 
• I08 Detecting and Preventing Undesirable Access Path Changes when Moving to DB2 Vnext
• I09 Stabilizing Access Paths Across Rebind
• I11 When Replication Is the Integration Solution
• I13 What’s New - OMEGAMON XE for DB2 PE V410 Extensions
• I14 Ding Dong the Quiesce is Dead!

Spotlight Session

• X01 Spotlight Session: Future DB2 for z/OS Technology Directions from DB2 Development