Advance DB2 DBA/System Admin/Programming (L2) Training

ADVANCE DB2 DBA/System Admin/Programming (L2) Training – Duration 50-60 Hours.

Training Contents:

Theory Sessions:

Name of the Topics

1 Z/OS Architecture Overview with respect to DB2

2 Types of work Loads in the Z/OS DB2 Environment
– DB2 Offline / Batch Work Load
– DB2 Online Work Loads
– The work flow of batch and online in DB2 environment
– How to define various types of workloads in the DB2 environment

3 DB2 Architecture Overview
– DB2 system structures
– DB2 Data Structures

4 Control and Maintenance of DB2
– Commands
– Utilities

5 DB2 and Z/OS Environment
– Address Spaces
– DB2 and Z/OS Mainframe system
– DB2 Lock Manager
– DB2 and Z/OS Security Server
– DB2 and DFSMS
– DB2 and TSO Attachment Facility
– DB2 and CICS
– DB2 and DDF
– DB2 and Parallel Sysplex

6 Design of DB2 databases in across various Production / Development / Test Environments
– Design of DB2 Databases
– Design of DB2 tables and views
– Design of DB2 table spaces
– Design of DB2 columns and Indexes
– Design of DB2 data constraints
– Design of DB2 storage Groups and maintaining them.
– Implementing the DB2 Database Designs

7 Estimating DASD Storage for DB2 User data

8 Altering the DB2 database designs

9 Security and Auditing implementation in Z/OS DB2
– Introduction to Security and
– Controlling Access to DB2
– Controlling Access to DB2 Subsystem
– Protecting DB2 Datasets

10 Core DB2 DBA functions across all the environments
– Load the Data to table spaces
– Unload the Data from databases
– Creation of indexes on the tables
– Creation of views on single / Multiple tables
– Creation of synonyms / Alias
– Creation of Tables / Table spaces / Databases
– Run the COPY, Check data, check index utilities on DB2 table spaces
– Run the QUIESCE utility on the table spaces / Databases
– Run the Recovery, Rebuild, repair, Modify, Reorg, Runstat and other more DB2 databases related utilities on the tables spaces of various databases.

11 DB2 Performance Monitoring and Fine Tuning
– Planning for performance strategy for DB2 databases
– Analyzing the performance data
– Managing the DB2 threads
– Tuning the SQL Queries and other DB2 environmental parameters

12 DB2 operation and Recovery
– Monitoring and controlling DB2 and its connections
– Managing the log and bootstrap Datasets
– Restarting the DB2 subsystem after the recovery.
– Maintaining the consistency across all the DB2 systems
– Backup and Recovery of DB2 Databases

Labs on DB2 System Admin/Prog L2.

Sessions Lab Sessions
1 DB2 Database design
2 DB2 Database design altering
3 DB2 Security
4 DB2 DBA functions
5 DB2 Databases performance tuning concepts
6 DB2 database Recovery
7 DB2 Installation on Subsystem- Concepts
8 Additional Lab

For more details, please contact

Ramamoorthy. V
Managing Director
TecSaCon Technologies
080 40983831 / 9886526644 / 9538526644