Pre-requisites
Participants should be familiar with

• Programming using SQL and hands-on experience on any RDBMS.
  
• Introduction to MVS and basic knowledge of ISPF/PDF, JCL and VSAM

Description
Course designed to provide Database administration skills needed for installing, administering, tuning and web enabling of databases on Mainframe

Course Duration
5 days (Full time)

Course Content

DB2 Overview

• Security (DB2-RACF), DB2 address spaces
  
• Database, Table space and Sub systems
  
• Normalization & De-normalization
  
• Bind, Plan, DDL & DCL

DB2 Catalog and Directory

SQL Code & SQL status values

DB2 limits

DB2 Components & Objects

• Creation and management of databases, table spaces, tables and views

DB2 Utilities

• Data Organization Utilities
  •  LOAD
    
  •  REORG
    
    
• Data Consistency Utilities
  •  CHECK
    
  •  REPAIR
    
  •  DIAGNOSE

DB2 Commands

• DB2 Environment Commands
  
• DSN commands
  
• IMS and CICS commands
  
• TSO commands

DB2 Utilities

• Backup and Recovery
  • COPY, MERGECOPY, QUIESCE
    
  • RECOVER, REPAIR, REPORT RECOVERY

DB2 Logs - Active and Archive

Catalog Manipulation Utilities

• CATMAINT, MODIFY, RUNSTATS, STOSPACE

Distributed DB2

• Communications Database
  
• DRDA functions
  
• DRDA Architecture & Standards
  
• Distributing data using DB2
  
• Two-Phase Commit

DB2 Stored Procedures

• Stored Procedures
  
• Implementing DB2 stored procedures

Data sharing

• Data sharing benefits & requirements
  
• DB2 Coupling facility
  
• Data sharing Administration & Guidelines

The Optimizer

• How the optimizer works?
  
• Filter factors
  
• Access Path Strategies
  
  

Locking DB2 Data

• Lock Types
  
• Locks Vs Latches
  
• Deadlock and Timeout

DB2 Performance monitoring and tuning

• EXPLAIN, PLAN_TABLE
  
• DB2 Traces, DB2-PM
  
• Tuning MVS
  
• Tuning DB2 components
  
• DB2 Resource governing

DB2 V5 & V6 new features

• ODBC
  
• Table spaces
  
• Type-2 index
  
• Dirty Read

DB2 and Internet