DB2-UDB-DBA

→ OVERVIEW OF DB2 PRODUCTS AND COMPONENTS

  • DB2 Products
  • Product components
  • Installation
  • Database Manager Instance and Administration
  • DB2 Administration Server (DAS)

→ CREATING DATABASES AND TABLESPACES

  • Overview of Database and Tablespace creation
  • Create Database and Tablespace Syntax
  • Schemas, Catalog Table and Views
  • Detailed Tablespace concepts
  • Buffer pools

→ DATABASE OBJECTS

  • DB2 Object Hierarchy
  • Database physical Directories/files
  • Tablespace and tables correlation
  • Creating Schema, Table, Index, Views and Alias

→ DATA MOVEMENT UTILITIES

  • Export/Import Utilities
  • Load Utility

→ RECOVERY

  • Recovery Introduction
  • Recovery Methods and Logging
  • Backup/Restore Utilities

→ MONITORING AND PROBLEM DETERMINATION

  • DB2 Diagnostics
  • Database Monitoring
  • Snapshot, Event and
  • DB2 Trace

→ ONCURRENCY

  • Locking Objects, Strategies and Modes
  • Isolation Levels
  • Other Factors Influencing Locks

→ DATA MAINTENANCE UTILITIES/PERFORMANCE TUNING

  • Reorg
  • Runstats
  • Reorgchk
  • Application Performance
  • Optimizer, Advisor and Binding
  • Utilities and Tools

→  SECURITY

  • Authentication and Authorization
  • Access Control
  • Explicit/Implicit Privileges
  • Querying Privileges and Authorities

→  DB2 Software's Migration

  • Migration
  • Upgrade

→ High  Availability

  • HADR Setup(primary/standby)
  • TAKEOVER

→  12.   REAL TIME SCENARIOS

Online Courses Videos