Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




DB2

This web-based training course on DB2 functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


This course helps trainees to learn about the relational database. DB2 supports multiple instances in a single system as it supports export, import, and load utilities to integrate data. With the help of this training program trainees can learn about DB2 environment, servers, clients, database objects. The course contents in this program includes overview of DB2, command line processor and GUI usage, database manager instance, to create database and placement of data, creating database objects, moving the data, data recovery and backup. With this course trainees will also get the exposure of locking and concurrency, security, log management, performance monitoring and advance monitoring. Furthermore, this course helps trainees to work with ER diagrams, operating system scripts, data studio and its installation.


Introduction to DB2

Pre requisites

  • Basic Operating system knowledge and Unix/Linux commands exposure
  • Basic knowledge on SQL commands and RDBMS concepts
  • DBA experience on any OLTP/OLAP environments is an added advantage

Course Outline

  • Overview of DB2 on Linux, UNIX and Windows
  • Command Line Processor (CLP) and GUI usage
  • Database Manager Instance
  • Creating databases and data placement
  • Creating database objects
  • Moving data
  • Backup and recovery
  • Database Maintenance, Monitoring and Problem Determination
  • Locking and concurrency
  • Security
  • Log Management
  • Performance Tuning
  • Advanced Monitoring
  • High Availability with DB2 database products
  • DB2 Replication (SQL)

Contents

  • DB2 family products overview (LUW, Mainframe, iSeries)
  • DB2 LUW product editions (Express-c to PureScale to InfoSphere)
  • DB2 product features and functions
  • DB2 client connectivity options (Data Studio, Data Server Client)
  • Introduction to DB2 CLP environment
  • Non-interactive mode
  • Interactive mode
  • db2 command line options
  • Client connectivity from Data Studio
  • About DB2 Instance
  • Database Manager Instance overview
  • DB2 instance creation pre-requisites
  • Create and Drop an instance
  • Starting and Stopping an instance
  • list and modify DBM configuration
  • db2set command
  • db2 history command
  • DB2 registry and environment variables
  • Product installation, extract and instance creation
  • Database creation pre-requisites
  • Database storage requirements
  • Table spaces overview
  • Storage management overview (SMS, DMS, Automatic)
  • Default Table spaces
  • CREATE DATABASE command
  • List DB configuration parameters
  • Modify DB configuration parameters
  • Database directories and files introduction
  • System catalog tables and views
  • Containers, extents, pages overview
  • CREATE TABLESPACE syntax
  • Storage groups overview
  • CREATE STOGROUP syntax
  • Assigning a tablespace to a storage group
  • Introduction to db2pd command
  • ALTER TABLESPACE, ALTER STOGROUP
  • DB2 LIST DB DIRECTORY
  • DB2 LIST NODE DIRECTORY
  • Activate and deactivate a database
  • Creating databases and data placement
  • DB2 object hierarchy
  • CREATE SCHEMA
  • CREATE TABLE, VIEW
  • CREATE ALIAS, INDEX, TRIGGER
  • creation of temporary tables
  • Creation of temporal tables
  • Table partitioning
  • Referential Integrity
  • Keys, Constraints
  • db2look CLI command
  • Authorization & Authentication
  • Creation of table spaces, tables, databases
  • IMPORT versus LOAD
  • Offline versus online load
  • LOAD QUERY TABLE
  • DB2 LIST UTILITIES
  • Pending states (Load, backup, set integrity)
  • EXPORT command
  • db2move cli command
  • ADMIN_MOV_TABLE procedure
  • Moving data using Export, Import, Load
  • Transactional logging (Circular, Archival)
  • Configure database logs
  • Backup utility options
  • Recovery utility options
  • ROLLFORWARD
  • DB2 RECOVER DATABASE
  • ONLINE versus OFFLINE backup
  • Backup and recovery
  • RUNSTATS utility
  • REORGCHK utility
  • REORG Utility
  • DB2 List commands
  • db2pd - Monitory and troubleshoot DB2
  • MON_GET_TABLE function
  • CREATE EVENT MONITOR
  • DB2 Optimizer
  • DB2 EXPLAIN
  • db2diag.log diagnostic log
  • db2trc command to obtain trace
  • db2fodc: collect diagnostic data for system hang
  • db2advis: Analyze workload
  • Using above DB2 Tools/Utilities
  • Importance of locking
  • Table lock modes
  • Row lock modes
  • Lock mode compatibility
  • Isolation levels
  • LOCK TABLE statement
  • Lock escalation, wait, and timeout
  • Deadlocks and detection
  • Using db2pd to identify locks, wait locks, deadlocks
  • Authentication versus Authorization
  • SYSADM, SYSCTRL, SYSMAINT, SYSMON
  • DBADM, SECADM, ACCESSCTRL
  • DB2 security privilege hierarchies
  • Grant and Revoke privileges
  • Database Security using grant/revoke
  • Database seeds
  • Log sequence numbers
  • db2ckbkp -l command
  • logfilsiz, logbufsz
  • Logprimary and Logsecond
  • db2pd to check logging activity
  • Log Archive processing
  • Log retrieval processing
  • MAX_LOG configuration parameter
  • Log archive/retrieval process
  • Analyze SQL statements
  • Create an access plan graph
  • db2exfmt tool
  • db2expln tool
  • Using Indexes for performance
  • Index usage statistics using db2pd
  • MON_GET_INDEX
  • MON_CONNECTION_SUMMARY view
  • Clustering indexes
  • db2advis command
  • Explain Tools, Indexes creation
  • GET SNAPSHOT command
  • In-memory metrics
  • Monitoring table functions
  • Administrative views, functions
  • Monitoring performance with SQL
  • Monitor heath with SQL
  • In memory metrics, SQLS, Admin views, functions
  • Automatic client reroute roadmap
  • DB2 fault monitor facilities for Linux and Unix
  • High Availability Disaster Recovery (HADR)
  • DB2 High Availability Feature
  • High Availability through Log Shipping
  • Log mirroring
  • High Availability through suspended I/O and online split
  • mirror support
  • DB2 HADR setup (1 primary, 1 standby creation, setup, communication)
  • DB2 Replication options (SQL, Queue)
  • Configuring 2 DB2 servers for SQL replication
  • Creation of control table for change capture
  • Register a table as source
  • Register a view of a table as a source
  • Capture table change
  • Apply table changes on target
  • Working with an existing SQL replication environment
  • DB2 SQL Replication setup between 2 RHEL DB2 LUW instances

DB2 has some unbelievable features which separate it from others as it is a very solid database. The methods DB2 uses for updating statistics, caching execution plans, storing XML data, and providing row-level data compression are really unmatched in quality. There are many job opportunities in the market after getting training, DB2 has a great future and its vast features will take it into the height of higher levels. DB2 provides cloud offering so the bigger enterprises data can be stored on it. With the help of DB2 performance of the system increases as it maximizes the cache and it also provides the best support for the impressive IBM POWER8 server architecture. Hence, this DB2 online training course is more application focused as compared to theory focused in order to give the trainees a profound usability experience and procedures.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.