Workshop (WDB04)

DB2 Introduction and Administration

DURATION: 40 hours

Content:
Overview of DB2 architecture and basic functionality
Description of the DB2 product family
DB2 access and administration tools
Managing database objects (tables, views, etc.)
SQL DB2 features
Transactional control and isolation levels
Installation and initial configuration of a DB2 instance
Managing connectivity to DB2
Database creation and space management
Data movement utilities
Backup and restore
Monitoring and problem determination tools
Memory and process management
Reorganization, statistics update and health check utilities
DB2 access security

Recommended for:

Database administrators (DBAs), system administrators and developers who need to know the functionality and/or manage a DB2 database environment.

Skills acquired:

Knowledge of data types and activities for creating tables, views and indicators
Understanding the DB2 architecture and the different ways of access, in terms of communication protocols
Knowledge to create and maintain DB2 instances and databases
Define and implement the best disk space allocation and management strategy and mechanisms
Knowledge of tools and commands used in DB2 administration and access
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

Prerequisites:
Basic SQL language knowledge (SELECT, INSERT, DELETE, UPDATE)
Knowledge of basic concepts of relational database design (desirable)
Knowledge of UNIX and/or Windows environment (desirable)

Duration:
5 days (9am to 6pm)

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