Dear Student/Professional,

Greetings from Etraining.guru

We provide the BEST DB2 DBA online training. Our instructor comes with 10+ years of experience.

For further details: http://www.etraining.guru/online-training-db2-luw-udb-dba.aspx

Course Contents:
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

Detailed Contents
Unit 1: Overview of DB2 on Linux, UNIX and Windows (1 hour)

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)
Unit 2: Command Line Processor (CLP) and GUI usage (1 hour)

Introduction to DB2 CLP environment
Non-interactive mode
Interactive mode
db2 command line options
Client connectivity from Data Studio
Unit 3: The DB2 Database Manager Instance (3 hours)

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
Exercise 1: Product installation, extract and instance creation
Unit 4: Creating databases and data placement (4 hours)

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
Exercise 2: Creating databases and data placement
Unit 5: Creating database objects (2 hours)

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
Exercise 3: Creation of table spaces, tables, databases
Unit 6: Moving data (3 hours)
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
Exercise 4: Moving data using Export, Import, Load
Unit 7: Backup and recovery (3 hours)

Transactional logging (Circular, Archival)
Configure database logs
Backup utility options
Recovery utility options
ROLLFORWARD
DB2 RECOVER DATABASE
ONLINE versus OFFLINE backup
Exercise 5: Backup and recovery
Unit 8: Database Maintenance, Monitoring and Problem Determination (3 hours)

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
Exercise 6: Using above DB2 Tools/Utilities
Unit 9: Locking and concurrency (2 hours)

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
Exercise 7: using db2pd to identify locks, wait locks, deadlocks
Unit 10: Security (1 hour)

Authentication versus Authorization
SYSADM, SYSCTRL, SYSMAINT, SYSMON
DBADM, SECADM, ACCESSCTRL
DB2 security privilege hierarchies
Grant and Revoke privileges
Exercise 8: Database Security using grant/revoke
Unit 11: Log Management (2 hours)

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
Exercise 9: Log archive/retrieval process
Unit 12: Performance Tuning (3 hours)

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
Exercise 10: Explain Tools, Indexes creation
Unit 13: Advanced Monitoring (2 hours)

GET SNAPSHOT command
In-memory metrics
Monitoring table functions
Administrative views, functions
Monitoring performance with SQL
Monitor heath with SQL
Exercise 11: In memory metrics, SQLS, Admin views, functions
Unit 14: High Availability with DB2 Database products (2 Hours)

High Availability options in DB2
DR options in DB2
High Availability Disaster Recovery (HADR)
High Availability through Log Shipping
Log mirroring
High Availability through suspended I/O and online split mirror support
Exercise 12: DB2 HADR setup (1 primary, 1 standby creation, setup, communication

Thanks,
www.etraining.guru