Workshop (WDB06)

DB2 UDB administration and performance and tuning

DURATION: 40 hours

Content:

DB2 architecture and components
Manage connectivity to DB2
Database creation and space management
Creating and maintaining objects
Data movement utilities
Backup and restore
Monitoring and problem identification tools
Process and memory management
Reorganization, statistics update and health check utilities
Optimizer and statistics
Diagnosis and problem identification
Concurrency control and blocking
Performance utilities
Performance settings and adjustments


Recommended for:

Database administrators (DBAs), system administrators and developers who need to manage a DB2 database environment

Skills acquired:

Knowledge to create and maintain DB2 instances and databases
Define and implement a better disk space allocation and management strategy and mechanism
Knowledge of tools and commands used in DB2 administration
Design and implement backup and restore strategies
Define and implement DB2 security and access strategies
Knowledge of the most used utilities for loading, exporting and reorganizing data
Monitor and identify problems in the DB2 environment
Knowledge of the internal architecture and functioning of DB2 processes and memory
Define and implement statistics update routines
Identify the impact of database design (tables, indicators, space allocation) on performance
Describe aspects of application development and how they affect performance
Identify the impact of database design (tables, indicators, space allocation) on performance
Identify and use as support tools for monitoring and tuning the DB2 environment.

Prerequisites:

Knowledge of SQL language
Knowledge of related database design concepts
Introduction to DB2 UDB
Knowledge of UNIX and/or Windows environment

Duration

5 days (9am to 6pm)

Are you interested or want to receive more information? Fill in the form to the side