Register for Demo Class

For Online Training

We are the No1 Leading Provider for Online Training

Video Reviews


Besant Technologies
5 Star Rating: Recommended 4.9 out of 5 based on 3802 reviews.

Review Source:

Bangalore Support

E : traininginblr[at]

BTM Layout :
+(91) 762 494 1772
+(91) 762 494 1774

Marathahalli :
+(91) 910 812 6341
+(91) 910 812 6342

Rajaji Nagar :
+(91) 734 915 0004
+(91) 734 916 0004
+(91) 755 011 2282 | +(91) 755 023 5062|traininginblr[at]

DB2 DBA Training in Bangalore

Home/DB2 DBA Training in Bangalore
DB2 DBA Training in Bangalore 2018-01-23T11:13:26+00:00

Session : 1 – 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

Session : 2 -Command Line Processor (CLP) & GUI Usage

  • Use the Command Line Processor
  • Explore the GUI environment
  • Describe the DAS role with GUI tools

Session : 3 -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

Session : 4 -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.

Session : 5 -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

Session : 6 – 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

Session : 7 – 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
  • 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

Session : 8 – 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

Session : 9 – 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

Session : 10 – 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

Session : 11 – Security

  • 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

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.


Quick Enquiry