|
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; 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 Storage Quantities; Using the CREATE Command to Complete Necessary Space Attribute; PRIQTY, SECQTY, FREEPAGE, PCTFREE, SEGSIZE, LOCKSIZE; 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; 3rd Party, After Market Vendor Tools for Monitoring/Managing DB2 Databases; DB2 Performance Tuning Utilities RUNSTATS, EXPLAIN and TRACE; DB2 Optimizer and Access Path Selection; Impact of SQL Coding on Performance;
Duration
9 hrs
Minimum Requirements
CGA Color Monitor 512K RAM 2.5MB Hard Disk Space DOS 3.3 or Higher Copyright © 1997 FirstClass Systems Corporation.
Media
|
