DB2 DBA Training

DB2 DBA Training Institute in Chennai & DB2 DBA Training in Chennai with Placement & DB2 DBA Training Center in Chennai

IICT Chromepet, Chennai provides real-time and placement focused DB2 DBA training in chennai . Our DB2 DBA 10g 11g dba course includes basic to advanced level and our DB2 DBA course is designed to get the placement in good MNC companies in chennai as quickly as once you complete the DB2 DBA certification training course. Our DB2 DBA trainers are DB2 DBA 10g 11g dba certified experts and experienced working professionals with hands on real time multiple DB2 DBA projects knowledge. We have designed our DB2 DBA course content and syllabus based on students requirement to achieve everyone's career goal.

Our DB2 DBA training center is equipped with lab facilities and excellent infrastructure. We also provide DB2 DBA certification training path for our students in chennai. Our DB2 DBA course fee is value for money and tailor-made course fee based on the each student's training requirements. DB2 DBA training in chennai conducted on day time classes, weekend training classes, evening batch classes and fast track training classes.


DB2 DBA Training

Overview of DB2 9.7 on Windows

Contrast the DB2 Family of products

Identify the DB2 Tools

Functions of DB2 components

Explore installation and parameters


Command Line Processor (CLP) & GUI Usage

Use the Command Line Processor

Explore the GUI environment

Describe the DAS role with GUI tools


The DB2 Environment

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 Databases and Data Placement

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.


Creating Database Objects

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


Moving Data

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

Backup And Recovery

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


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


Locking And Concurrency

Explain why locking is needed

List objects that can be locked

Describe and discuss the various lock modes and their compatibility

Explain four different levels of data protection

Set isolation level and lock time out for current activity

Explain lock conversion & escalation

Describe causes of Deadlocks


Problem Determination

Collect information for problem analysis and resolution

Use error logs for basic problem analysis

Describe four types of monitors: Snapshot Monitor, Event Monitor, Activity Monitor and Health Monitor

Basic commands to better work with connections and Sessions

Retrieve statistics and information from a running DB2 instance


Application Issues and Performance

Prepare applications that access DB2 data for execution

Describe the application alternatives available to access DB2 data

Define the concept of clustering, and determine the proper cluster sequence

Use RUNSTATS, REORGCHK, and REORG to enhance application performance

Work with the EXPLAIN facility



Use Access Control Mechanisms to implement database security

Use group IDs to create a control hierarchy

Describe Label Based Access Control

Describe privileges within a database

Describe privileges required for binding and executing a package

Describe the difference between explicit privileges & implicit privileges

Describe the different level of authorization


DB2 DBA Trainer profile in Chennai

More than 7 Years of experience in DB2 DBA Technologies

Has worked on 5 realtime DB2 DBA projects

Working in a MNC company in Chennai

Trained 50+ Students so far.

Strong Theoretical & Practical Knowledge

DB2 DBA certified Professional


Frequenty Asked Questions


Training Experiences with Us