DB2 Database Administration

DB2 Training in Chennai

DB2 Universal Database (UDB), from IBM, runs everything from handhelds to servers to mainframes. IBM offers several versions to run on many different platforms, enabling flexibility and compatibility across the varied needs of a corporate environment.

DB2 for z/OS is the mainframe version of the database. The cost, performance and stability of z/OS Mainframe computers has led to a renaissance of Big Iron in the market. At the same time, the DB2 DBAs needed to manage this growth are rapidly decreasing due to retirement, redeployment to higher-value initiatives, and turnover.

The DB2 DBA talent shortage is global; traditional outsourcing, therefore, is not a solution. Training is, at best, a long-term option. There are few university and corporate training opportunities for mainframe database administration skills and on-the-job apprenticeship programs take years to mature. We offer best db2 dba training in chennai with real time projects.

Course Content:


  • Rdbmsconcepts
  • Normalisation
  • Query writing skills

Section 1 - DB2 Server Management

  • Configure/manage DB2 instances (e.g. scope)
  • Obtain/modify database manager configuration information
  • Obtain/modify database configuration informationd
  • Knowledge of the DB2 force command
  • Configure client/server connectivity
  • Scheduling jobs
  • Ability to use Automatic Maintenance (i.e., RUNSTAT, Backup, REORG)
  • Skill in interpreting the Notify log
  • Ability to obtain and modify DB2 registry variables
  • Ability to use Self-tuning memory managemer and autoconfig
  • Ability to use Throttling utilities
  • LVM

Section 2 - Data Placement

  • Create a database
  • The use of schemas
  • The various table space states
  • Create and manipulate the various DB2 objects
  • Create and discuss the characteristics of an SMS tablespace
  • Ability to create and discuss the characteristics of an automated managed tablespace
  • Knowledge of partitioning capabilities(e.g,Table partitioning,Hash partitioning,MDC,Hybrid)
  • Knowledge of XML structure (indexing for performance)
  • knowledge of compression data

Section 3 - Database Access

  • Knowledge of the creation and management of indexes
  • Ability to create constraints on tables (e.g., RI, Informational, Unique)
  • Ability to create views on tables
  • Skill in examining the contents of the System Catalog tables
  • Ability to use the GUI Tools for administration
  • Knowledge of how to enforce data uniquenes

Section 4 - Analyzing DB2 Activity

  • Ability to capture and analyze EXPLAIN/VISUAL EXPLAIN information
  • Ability to capture snapshots using Get Snapshots or SQL function
  • Ability to create and activate event monitors
  • Ability to configure Health Monitor using the Health Center
  • Ability to identify the functions of Problem Determination Tools (e.g, db2pd, db2mtrk)

Section 6 - High Availability

  • Ability to perform database-level and table space level BACKUP & RESTORE
  • Knowledge to identify and explain issues on index recreation
  • Knowledge of database logging
  • Knowledge of crash recovery
  • Knowledge of Roll Forward recovery
  • Knowledge of version recovery
  • Knowledge of and ability to perform HARD
  • Knowledge of and ability to perform Log Mirroring
  • Knowledge of Configurable Online Parameters

Section 7 - Security

  • Knowledge of DB2 authentication
  • Knowledge of DB2 authorizations
  • Ability to set user and/or group privileges
  • Knowledge of the DB2 Security Infrastructure (e.g. LBAC and Security Plug-ins)

(c) 2013 Sakthi Software Solutions Pvt.Ltd. All Rights Reserved