DB2 Design & Administration (ver 3.1)

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

Provides the knowledge for database administrators and designers who need to monitor and tune a DB2 database for maximum performance.

Audience

Database Administrators, Analysts and Systems Designers.

Prerequisites

Thorough knowledge of DB2.

Topics Include

Introductory Concepts Four Major Goals of a Database; Management System; Structure of a Relational Database; Relational Database Structure; Conceptual Design Designing Tables and Normalizing to 3rd Normal Form; Appropriate Primary/Foreign Keys;Design Considerations that Impact Efficiency and Performance; Implementing the Conceptual Design DB2 OBJECTS: DATABASE, TABLESPACE, TABLE, INDEX; Creating DB2 Objects using DDL Command CREATE; Performance and Efficiency Considerations: Bufferpools, Storage Groups, Lock Contention, Concurrency/Lock Avoidance; Indexes Usage and Physical Implementation of Indexes; Roles and Creation of Clustering Indexes; Impact of Index Usage on Performance/Efficiency; referential Integrity DB2 Referential Integrity vs.User Enforced Referential Integrity; RI Rules and Options for DELETE, UPDATE, INSERT Commands; DB2 Storage Definition Estimating/Calculating Space Requirements; Using the CREATE Command Space/Storage Parameters: PRIQTY, SECQTY, FREEPAGE, PCTFREE, SEGSIZE, LOCKSIZE, COMPRESS; Managing Database Space Requirements; Security Using GRANT and REVOKE Commands to Authorize and Remove Database Authority; Security and Hierarchy Access; Database Management DML Commands ALTER and DROP; Monitoring DB2 Activity using the DB2 Catalog; Third Party, After Market Vendor Tools for Monitoring/Managing DB2 Databases; DB2 Performance Tuning Query I/O Parallelism; Utilities RUNSTATS, EXPLAIN and TRACE; DB2 Optimizer and Access Path Selection; Impact of SQL Coding on Performance;

© Copyright Serebra Learning Corp., 2002