Workshop (WDB02)

DB2 UDB Administration

Basic DB2 architecture and components
Installation and initial configuration of a DB2 instance
Managing connectivity to DB2
Database creation and space management
Creating and maintaining objects
Data movement utilities
Backup and restore
Monitoring and problem identification tools
Memory and process management
Reorganization, statistics update and health check utilities
Scheduling and running tasks
DB2 access security
Performance considerations

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 the best disk space allocation and management strategy and mechanisms
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

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

5 days (9am to 6pm)

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