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:   PROGRAM PREPARATION: Components DCLGEN Precompile Bind Plan & Catalog table interaction Packages Catalog table interaction Benefits Systematic Rebind Versions Performance Issues Collections SELECTED DSNZPARM PARAMETERS: Locking Logging Timeout Active Users EDM Pool Bufferpools Hipepools 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 STORED PROCEDURE: Parameters NULLs Result Set Processing Management DISPLAY START STOP Global Temporary Tables Compiler Considerations LOCKING: Locks Latches BIND Impact Dirty READs Tablespace Locks Table Locks Page Locks Row Locks Claims Drains Lock Avoidance Guidelines WEB RESOURCES: Discussion of various URLs and situations where their use is appropriate 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