IBM DB2 v9: Administration for LUW (Linux, Unix, Windows) UK Classes & Lessons (DBA)

About this class

The Course is designed to instruct those delegates attending the course how to perform database administration activities on DB2 in a Linux, UNIX or Windows environment. Those activities include all aspects of manual or automatic maintenance, utilities, problem determination, parallelism, distributed data management, remote administration, MDT, Health Center, federated databases and DB2 Governor.

This training may be available onsite; please contact us if you are interested.

Who will the lesson benefit?

Systems Administrators, Database Administrators and technical personnel who are involved in all stages of designing planning, implementation and maintaining DB2 for LUW Databases. The course is delivered up to DB2 9.

What prerequisites are required

Delegates are expected to have relevant operating system experience (i.e. Linux, UNIX or Windows) and knowledge of relational database theory and SQL. Previous experience of using DB2 is recommended.

Contents of this class

Introduction to DB2

The DB2 family
The Big Picture
Basic Terms
DB2 System Catalog
Attributes
SQL Execution
Control Center
DDL
Practical Exercise

Indexing

Design Advisor
Practical Exercise

RUNSTATS

REORG
Access Strategies
Practical Exercise
Explain
Visual Explain
Practical Exercise

MDC

Automatic Computing
Configuration Parameters
Collecting Catalog Statistics
Activity Monitor
Memory Visualization
Health Center
Remote Administration
DB2 Administration Server
Configuration Assistant
Instance Attachment
Connection
The Governor and Audit

Problem Determination Tools and Techniques

Parallelism and SMP Enablement
Utilities
db2move
db2look
db2ocat
db2cfexp
db2cfimp
List Utilities

Capacity Management

Estimate Size
Storage Management
Database Container Operations
High Availability Monitor

Advanced Load

Distributed Management
Federated Databases
Configure Multisite Update
Journal
Replication Center
Task Center
Event Analyzer
Recommendation Adviser
Indoubt Transaction Manager