IBM DB2 DBA Online Training 

offered by Besant Technologies, Velachery - Chennai

Contrast the DB2 Family of products

Identify the DB2 Tools

Functions of DB2 components

Explore installation and parameters

Use the Command Line Processor

Explore the GUI environment

Describe the DAS role with GUI tools

Key features of an Instance

Create and drop an Instance

Use db2start and db2stop

Distinguish b/w types of Config.

Describe and modify the Database Manager Configuration

Creating a Database.

Explore system Catalog tables, views

Compare DMS Vs SMS table Spaces.

Database with Automatic Storage.

Differentiate between table spaces, containers, extents, and pages

Define table spaces

Get snapshot for table spaces

Explore Database Config. Parameter

List DB2 object hierarchy and physical directories & files

Creating objects: Schema, Table, View, Alias, and Index

Explore the use of table partitioning

Review the use of Temporary Tables

Implementation of Check Constraints, Referential Integrity and Triggers

Exploring the use of Large Objects

Discuss the INSERT statement and Recognize its limitations

Explain the differences between IMPORT and LOAD

Explain the EXPORT, IMPORT, and LOAD syntax

Create and use Exception Tables and Dump-Files

Distinguish and Resolve Table States: Load Pending and Set Integrity Pending

Use the SET INTEGRITY command

Discuss the db2move and db2look commands

Describe the major principles and methods for backup and recovery

State the three types of recovery used by DB2

Explain the importance of logging for backup & recovery

Describe how data logging takes Place ?circular & archival logging

Use the BACKUP, RESTORE, and ROLLFORWARD commands

Perform a table space backup and recovery

Restore a database to the end of logs or to a point-in-time

Backup and recovery scenarios