Verhoef Training Europe.

11B Kingsmead Square, Bath, BA1 2AB, UK
Phone:+44 (0)1753 852 233 Fax: +44 (0)1753 840 190



Advanced DB2 Administration Workshop




AUDIENCE:   Senior Application Programmers, Project Managers, Team Leaders, Database Analysts, Database Administrators, System Administrators and System Programmers who have worked with DB2.

PREREQUISITES:   Previous DBA experience is required.

DURATION:   4 Days

APPROACH:   This class is taught by lecture with hands-on workshops.

COURSE CONTENT:  

  1. PROGRAM PREPARATION:

    • Components
    • DCLGEN
    • Precompile
    • Bind
    • Plan & Catalog table interaction
    • Packages

      Catalog table interaction
      Benefits
      Systematic Rebind
      Versions
      Performance Issues

    • Collections

  2. SELECTED DSNZPARM PARAMETERS:

    • Locking
    • Logging
    • Timeout
    • Active Users
    • EDM Pool
    • Bufferpools
    • Hipepools

  3. UTILITIES:

    • COPY
    • MERGECOPY
    • QUIESCE
      (including use of QUIESCE `shadow table')
    • RECOVER
      (including Business Continuation if requested (add _ day))
    • CHECK
    • REPAIR
      (only restriction lifting REPAIR options covered)
    • REORG
    • LOAD

  4. STORED PROCEDURE:

    • Parameters
    • NULLs
    • Result Set Processing
    • Management

      DISPLAY
      START
      STOP

    • Global Temporary Tables
    • Compiler Considerations

  5. LOCKING:

    • Locks
    • Latches
    • BIND Impact
    • Dirty READs
    • Tablespace Locks
    • Table Locks
    • Page Locks
    • Row Locks
    • Claims
    • Drains
    • Lock Avoidance
    • Guidelines

  6. WEB RESOURCES:

    • Discussion of various URLs and situations where their use is appropriate

  7. PERFORMANCE:
    * * WARNING THIS TOPIC TENDS TO BE VERY TIME CONSUMING * *

    • Navigational Queries
      (for DBA analysis of objects and their dependencies
    • Physical Analysis Queries
    • Parallelism
    • Programmer Queries
    • Catalog Queries
    • Memory (EDM pool, Buffer Pools, etc.)
    • CPU usage Tuning I/O Tuning
      (index usage, system, sort, application, etc.)
    • Catalog Tuning
    • Collecting TRACE Information
      (SMF, IFCIDs, etc. (add _ day))
    • Guidelines & Strategies

© 2007 Verhoef Training