DB2 DBA training

DB2 DBA Training

DB2 is one of the powerful RDBMS software help to achieve high voluminous data and accommodates special CLOB, BLOB data types. DB2 is compatible with various operating systems and federates with different types of databases. DB2 is one of the leading Web-based databases. DB2 is a Universal Database (UDB). DB2 Universal Database (UDB) supports many different types of applications and data types in various environments.




About The Course

DB2 support multiple instances in a single system. Supports Export, Import, Load and DB2move utilities to integrate data.DB2 is one of the powerful RDBMS software help to achieve high voluminous data and accommodates special CLOB, BLOB data types. DB2 is compatible with various operating systems and federates with different types of databases. DB2 is one of the leading Web-based databases. DB2 is a Universal Database (UDB). DB2 Universal Database (UDB) supports many different types of applications and data types in various environments.

What are the pre-requisites for this Course?

Should have the knowledge on SQL.

DB2 DBA Training Details

  1. Installations and the DB2 editions
  • DB2 software installations and upgrades
  • DB2 Servers
  • DB2 Clients
  • DB2 software packaging
  1. DB2 environment
  • The big picture
  • The Instances
  • The Databases
  • DB2 Environment
  • DB2 Configuration
  • Database and Instance config parameters
  • DB2 Registry variables
  1. DB2 Architecture
  • DB2 Process Model
  • DB2 Memory Model
  • Storage Model
  • Parallelism
  1. Client Connectivity
  • DB2 directories
  • Configuration required at the server
  • Configuration required at the client
  • Catalog Statements
  • Methods to setup connectivity
  1. Database Objects
  • Tables
  • Indexes
  • Views
  • Schemas
  • Tablespaces
  • Bufferpools
  1. Datatypes and SQL
  • Numeric (Integer, Decimal, float)
  • String (Char, Varchar, CLOB)
  • Datetime (Date, Time, Timestamp)
  • XML
  1. Data movement utilities
  • Export
  • Import
  • Load
  • Set Integrity
  • db2move
  • db2look
  1. Backup
  • Database logging: Circular & Archive
  • Backup types: Off-line & on-line, delta, incremental, tablespace
  • Backup command
  1. Recovery
  • Recovery types: Crash, Version &Rollforward recovery
  • Restore command
  • Rollforward command
  • Redirect restore
  1. Performance Tuning
  • Database statistics
  • Explain SQL
  • Understand the Access Plan
  • Table Partitioning
  • MQTs & MDCs
  • System performance (vmstat, iostat, top)
  1. Maintenance
  • Reorg
  • Runstats
  • Rebind
  • Automatic maintenance
  1. Concurrency and Locking
  • Concurrency
  • Isolation Levels
  • Locking
  • Lock escalation
  • Lock Wait
  • Deadlocks
  1. Monitoring
  • Snapshot monitor
  • Event monitor
  • Table functions
  • SYSIBMADM views
  1. Database Security
  • Authentication
  • Authorization
  • Privileges
  • Groups, Users, Roles
  • Grant & Revoke commands
  • LBAC, Row and Column level access control
  1. Application Objects
  • Stored Procedures
  • UDFs
  • Triggers
  1. Server Management
  • Start and stop the instance
  • Start and stop the database
  • Updating db and dbm configuration parameters
  • Configuring the registry variables
  1. Troubleshooting
  • The help (?) command
  • The notification log
  • The diagnostic log
  • The CLI and DB2 tracing
  • The information Center
  • Creating the PMRs

  • Can I get recorded sessions of a live class?

    Yes, this can be done. Moreover, this ensures that when you will start with your batch, the concepts explained during the classes will  be recorded and available to you .

  • How will I execute the Practicals?

    We will help you to setup the required environment for practicals.

  • I have a windows system. Can that be used to work on the assignments?

    Yes, One can always use Windows to work on assignments. Our 24*7 team support will guide you to get the set-up ready.

Towards the end of the course, you will be working on a real time Project.

CONTACT US

Online Classroom

19th Dec
Monday
9PM-10PM EST
$500
23rd Dec
Friday
9PM-10PM EST
$500

Course Feature

Online Classes: 30 Hrs

30 live classes of 1 hrs each by Industry practitioners

Assignments: 15Hrs

Personal assistance/installation guides for setting up the required environment for Assignments / Projects

Project: 10Hrs

Live project based on the selected use cases.

Lifetime Access: Life time

Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

24 x 7 Support

Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

Get Certified

Vidhyalive certified ‘DB2 DBA Expert’ based on your project performance, reviewed by our expert panel